----------------------------------------------------------------
原贴内容:
SET IDENTITY_INSERT ON
要列出列名。TABLOCKX SET IDENTITY_INSERT datebase1.dbo.table1 ON
insert datebase1.dbo.table1 WITH(TABLOCKX) (ID,F1,F2,F3,F4.....) select ID,F1,F2,F3,F4.... from table1 where sign = @sign
SET IDENTITY_INSERT datebase1.dbo.table1 OFF
delete from table1 where sign = @sign
原贴内容:
SET IDENTITY_INSERT ON
要列出列名。TABLOCKX SET IDENTITY_INSERT datebase1.dbo.table1 ON
insert datebase1.dbo.table1 WITH(TABLOCKX) (ID,F1,F2,F3,F4.....) select ID,F1,F2,F3,F4.... from table1 where sign = @sign
SET IDENTITY_INSERT datebase1.dbo.table1 OFF
delete from table1 where sign = @sign
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货