ET IDENTITY_INSERT

允许将显式值插入表的标识列中。

语法

SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }

 

SET IDENTITY_INSERT dbo.UserDB ONINSERT INTO UserDB(ID,UserName,HomeURL) VALUES (2,'NULL','www.51laugh.cn')PRINT 'OK思密达'SET IDENTITY_INSERT dbo.UserDB OFF