----------------------------------------------------------------
原贴内容:
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