while不支持嵌套麽？？
DECLARE @A INT
DECLARE @AA INT

DECLARE @B INT
DECLARE @BB INT

SET @A=1
我想使用2个循环打印出100个A
------------
SET @AA=10

SET @B=1
SET @BB=10

WHILE @A <=@AA
BEGIN
WHILE @B <=@BB
BEGIN
PRINT 'A '
SET @B= @B+1
END
SET @A=@A+1
END

[解决办法]
--try
DECLARE @A INT
DECLARE @AA INT

DECLARE @B INT
DECLARE @BB INT

SET @A=1
SET @AA=10

SET @B=1
SET @BB=10

WHILE @A <=@AA
BEGIN
WHILE @B <=@BB
BEGIN
print 'A '
SET @B= @B+1
END
select @A=@A+1,@B = 1
END

[解决办法]

DECLARE @A INT
DECLARE @AA INT

DECLARE @B INT
DECLARE @BB INT

SET @A=1
--我想使用2个循环打印出100个A
------------
SET @AA=10

SET @BB=10

WHILE @A <=@AA
BEGIN

SET @B=1 --这里要赋初值

WHILE @B <=@BB
BEGIN
PRINT 'A '
SET @B= @B+1
END
SET @A=@A+1
END