DECLARE
@iStart INT
DECLARE
@iEnd INT
DECLARE @i INT
DECLARE
@iCount INT
SET @iStart = 1
SET @iEnd = 1000
SET @i=@iStart
WHILE (@i <= @iEnd) BEGIN
SELECT @iCount = COUNT(1) FROM TableName WHERE A = @i
IF @iCount = 0 BEGIN
INSERT INTO TableName (A)
SELECT @i
END
SET @i=@i+1
END
需要procedure封装才能在数据库以函数形式执行