我有两个表,incases和incaserecords其中主关键字incaseno和incaserecordno是identity列,incaserecords.incaserecordno和incases.incaseno以incaseno关联,现在想做一个存储过程,当insert到incases后取incasesno的值,在insert到incaserecords时用到,应该怎么做呢?
自己写的运行时出错,错误提示为:
An explicit value for the identity column in table 'incaserecords' can only be specified when a column list is used and IDENTITY_INSERT is ON.
各位高手,请指点,急用的!谢了
---------------------------------------------------------------
insert into incaserecords values(@in_no,@merchandiseid,@inquantity,@inprice,@indiscount,@inmayang,@inshiyang,@date,@operatorid,@istuihuo)
改成：
insert into incaserecords values(@merchandiseid,@inquantity,@inprice,@indiscount,@inmayang,@inshiyang,@date,@operatorid,@istuihuo)
或者
SET IDENTITY_INSERT incaserecords ON
insert into incaserecords （
incaserecordno ,
incaseno ,
merchandisesid ,
inquantity ,
incasemayang ,
incaseshiyang ,
indate ,
operatorid ，
istuihuo
） values(@in_no,@merchandiseid,@inquantity,@inprice,@indiscount,@inmayang,@inshiyang,@date,@operatorid,@istuihuo)
SET IDENTITY_INSERT incaserecords OFF