求高手帮忙看下这段SQL 代码？实在是想不出什么好办法了啊！！（提建议者+分）(50分)

set @sql='insert into worknot select a.workno,b.countnum,b.ctime from (select * from Tworktech where '+@tech+') as a,(select workno,countnum,ctime &nbsp;from tmember where status=1 and &nbsp;marking=2) as b where a.workno=b.workno'<br>其中 @TECH=‘english&gt;1’假设吧 worknot 表中有四个字段，workno,countnum,ctime,lstime..<br>按上面那样插入肯定是不对的，应为插入的字段列，小于表里面的，我已经试过了，<br>现在问题就出现了。我想把 @times=getdate() 当前时间变量也插入到的表WORKNOT 里面对应的是ctime<br>如果用上面的代码怎么办啊怎么才能才能插入@time 这个时间变量啊。<br>不要分开插入啊。我想一起执行完所有的插入字段内容。上面只是三个字段内容。<br>高手们给指点些吧！！！

我说的不清楚吗？》大家看看给点指教啊！

set @sql='insert into worknot(workno,countnum,ctime) select a.workno,b.countnum,b.ctime from (select * from Tworktech where '+@tech+') as a,(select workno,countnum,ctime &nbsp;from tmember where status=1 and &nbsp;marking=2) as b where a.workno=b.workno'<br>或者<br>set @sql='insert into worknot(workno,countnum,ctime) select a.workno,b.countnum,getdate() as ctime from (select * from Tworktech where '+@tech+') as a,(select workno,countnum,ctime &nbsp;from tmember where status=1 and &nbsp;marking=2) as b where a.workno=b.workno'

TO ：dey_999<br>你写的长度好象超出了

什么状况啊,关键是insert into worknot(workno,countnum,ctime),其他都没有改啊,是不是你自己的字段长度不统一啊

TO ：dey_999<br>能不能直接写<br>set @sql='insert into worknot select a.workno,b.countnum,getdate() as ctime from (select * from Tworktech where '+@tech+') as a,(select workno,countnum,ctime &nbsp;from tmember where status=1 and &nbsp;marking=2) as b where a.workno=b.workno'<br>把(workno,countnum,ctime) 去掉

对了。谢谢楼上了，马上给你加分