insert into ff
(ffyear,ffmonth,ffmoney,empcode,empname,acctno)
select
:ss1,:ss2,
retiree.retiwage,
retiree.empcode,
retiree.empname,
retiree.acctno
from retiree
where retiree.sflag='0';
如直接用2003,11可通过。
...全文
231打赏收藏
请朋友们看看这句SQL错在哪里?
int ss1=2003,ss2=11 insert into ff (ffyear,ffmonth,ffmoney,empcode,empname,acctno) select :ss1,:ss2, retiree.retiwage, retiree.empcode, retiree.empname, retiree.acctno from retiree where retiree.sflag='0'; 如直接用2003,11可通过。