插入自增字段数据

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

 

转载于:https://www.cnblogs.com/Jeremy2001/p/9973898.html