好傻的WHILE循环插入，谁能帮我把这个WHILE给变成一句话插入？
DECLARE @A1 INT
DECLARE @A2 INT
SELECT @A1 = MIN( ISNULL(AA00100, 0) ), @A2 = MAX(AA00100) FROM AA001 WHERE STATUS = 1
CREATE TABLE #T
(
ID int IDENTITY(1,1),
WORKCODE int not null,
)
－－－－－－－－－－－－－－－－－－－－－－－－－－－
WHILE @A1 < @A2
BEGIN
INSERT INTO #T (WORKCODE) VALUES (@A1)
SET @A1= @A1+1
END
－－－－－－－－－－－－－－－－－－－－－－－－－－－
SELECT * FROM #T
DROP TABLE #T
[解决办法]
select identity(int,1,1) as id
into #t
from sysobjects
[解决办法]
DECLARE @a INT
DECLARE @b INT
SELECT @a=ISNULL(MIN(AA00100),0),
@b=MAX(AA00100)
FROM AA001 WHERE STATUS = 1
SELECT IDENTITY(INT,1,1) AS id,
@a AS WORKCODE
INTO dbo.#
FROM syscolumns
WHERE id <=@b
AND id> =@a
SELECT * FROM #
