① 一题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