Sql 嵌套循环

DECLARE @i INT ,@j INT
SET @i=1
set @j=1
WHILE @i<4
    BEGIN
        PRINT 'satrt  i:'+CAST(@i AS varchar)
    WHILE @j<4
        BEGIN
            PRINT 'j:'+CAST(@j AS varchar)
            SET @j=@j+1
        END
set @j=1
set @i=@i+1

END 
原文地址:https://www.cnblogs.com/accumulater/p/13085230.html