学步园

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