set @sql='insert 库存账本 (Dateandtime,pID,pDept,classid,jNum,jMoney,jSum,
cNum,cMoney,cSum,content,Counts,kc'+cast(@kcid as char(1))+')
values (@inDate,@pID,@iDept,@classid,@kNum,@price,@total
,@kNum,@price,@total,@content,@kNum,@kcNum)'
exec sp_executesql @sql
,N'@pID varchar(9),@inDate datetime,@kcid int,@iDept int,@classid int
@knum int,@price money,@total money,@content text'
,@pID ,@inDate ,@kcid ,@iDept ,@classid
@knum ,@price,@total,@content
cNum,cMoney,cSum,content,Counts,kc'+cast(@kcid as char(1))+')
values (@inDate,@pID,@iDept,@classid,@kNum,@price,@total
,@kNum,@price,@total,@content,@kNum,@kcNum)'
exec sp_executesql @sql
,N'@pID varchar(9),@inDate datetime,@kcid int,@iDept int,@classid int
@knum int,@price money,@total money,@content text'
,@pID ,@inDate ,@kcid ,@iDept ,@classid
@knum ,@price,@total,@content
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货