有一条sql语句没执行是怎么回事呀?请看...

Question

可能是因为你表的zz_bianma是个自增列

Answer 1

declare @a nvarchar(2200)
set @a=' insert into xsdinghuoku(zz_bianma,zz_name,a1,a2,goods_bianma,goods_name,goods_xinghao,goods_guige,fhquantity,kucun,paichan,jldanwei,fhjia,fhjine,kh_bianma,kh_name,ck_bianma,ck_name,danhao,picihao,caozuoyuan,xiadanren,rukuyuan,memo,fhdate) select '''+@zzbm+''','''+@zzname+''',a1,a2,goods_bianma,goods_name,goods_xinghao,goods_guige,fhquantity,kucun,paichan,jldanwei,fhjia,fhjine,'+@khbm+','+@khname+','''+@ckbm+''','+@ckname+','''+@dh+''',picihao,'+@czy+','+@cgy+','''+@rky+''','''+@bz+''','''+@fhrq+''' from scplanluruku_'+@gonghao
print @a   --检查你的SQL是否正确
exec (@a)         --执行SQL