① 一題T-SQL編程題。可能涉及表變數，while循環，臨時表
用存儲過程寫的，請採納
CREATE PROC test1
AS
begin
DECLARE @table TABLE(id INT IDENTITY,number INT)
DECLARE @i INT
DECLARE @j INT
DECLARE @number INT
SET @i=1
SET @j=1
WHILE @i<=1000
BEGIN
INSERT INTO @table(number)
SELECT CAST(RAND()*10000 AS INT)+1
SET @i=@i+1
END
WHILE @j<=1000
BEGIN
SELECT @number=number FROM @table WHERE id=@j
SET @j=@j+1
PRINT @number
END
END