-- 创建表 IF OBJECT_ID('tMyTable', 'U') IS NOT NULL DROP TABLE tMyTable GO CREATE TABLE tMyTable ( MyID int IDENTITY(3, 5) NOT NULL ) -- 添加记录 -- 1. 我的笨方法 DECLARE @tableRecordCount int SELECT @tableRecordCount = COUNT(*) FROM tMyTable DECLARE @nextIdentVal int IF (IDENT_CURRENT('tMyTable') = IDENT_SEED('tMyTable')) AND (@tableRecordCount = 0) SET @nextIdentVal = IDENT_SEED('tMyTable') ELSE SET @nextIdentVal = IDENT_CURRENT('tMyTable') + IDENT_INCR('tMyTable') SET IDENTITY_INSERT tMyTable ON INSERT INTO tMyTable (MyID) VALUES (@nextIdentVal) SET IDENTITY_INSERT tMyTable OFF -- 2. 正确的做法 INSERT INTO tMyTable DEFAULT VALUES