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
