Skip to navigation
Mssql batch insert with IDENTITY_INSERT of
27.06.14
SET IDENTITY_INSERT MYTABLE ON INSERT INTO [stock] (location,karat,style,gross,qty,wt,identity,code) VALUES('1' ,'0' ,'1' ,'0' ,'250' ,'0' ,'850' ,'') ,('1' ,'18' ,'18' ,'-2.454' ,'0' ,'6.042' ,'940' ,'18') ,('1' ,'18' ,'18' ,'-2.454' ,'0' ,'6.042' ,'941' ,'19') SET IDENTITY_INSERT MYTABLE OFF
Reply
Anonymous
Information Epoch 1746864177
Prototype before polishing. Get it working before you optimize it.
Home
Notebook
Contact us