sql server loops

    BEGIN
DECLARE @iMin INT;
        DECLARE @iMax INT;
        DECLARE @table TABLE
            (
              [ID] INT IDENTITY(1, 1) ,
              ColumnA DECIMAL(18, 4) ,
              ColumnB DECIMAL(18, 4) ,
              ColumnC VARCHAR(50) ,
              ColumnD TINYINT
            );

        INSERT  INTO @table
                SELECT  ColumnA1 ,
                        ColumnB1,
                        ColumnC1,
                        ColumnD1
                FROM    @TempTableSET @iMin = 1; 
        SELECT  @iMax = MAX(ID)
        FROM    @table;
        WHILE @iMin <= @iMax
            BEGIN 
                DECLARE @ColumnA DECIMAL(18, 4);
                DECLARE @ColumnB DECIMAL(18, 4);DECLARE @ColumnC VARCHAR(MAX);
                DECLARE @ColumnD TINYINT;SELECT TOP 1
                        @ColumnA = ColumnA,
                        @ColumnB= ColumnB,
                        @ColumnC= ColumnC,
                        @ColumnD= ColumnDFROM    @table
                WHERE   ID = @iMin;
        /*
IF ( ) BEGIN END; ELSE BEGIN END;
          */
SET @iMin = @iMin + 1; END; END;
posted @ 2018-04-11 18:49  小懒虫fei  阅读(108)  评论(0编辑  收藏  举报