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://q.cnblogs.com/q/39008/

转载于:https://www.cnblogs.com/keepSmile/p/10208202.html