root/trunk/sql/sqlserver/makeNumSeq.sql

IF EXISTS (SELECT * FROM dbo.sysobjects
  WHERE id = OBJECT_ID(N'dbo.makeNumSeq') AND
    OBJECTPROPERTY(id, N'IsProcedure') = 1)
  DROP PROCEDURE makeNumSeq
GO

CREATE PROCEDURE makeNumSeq(@maxNum INT) AS
BEGIN
  DECLARE @i INT
  SET @i=1
  DELETE FROM numSequence
  WHILE @i<=@maxNum
  BEGIN
    BEGIN TRANSACTION
    INSERT INTO numSequence (n) VALUES (@i)
    COMMIT
    SET @i=@i+1
  END
END
GO

EXECUTE makeNumSeq 500
GO