DECLARE
                  @SkuID AS INT,      
                  @SkuCode AS varchar(100),
                  @Skuname AS varchar(500),
                  @PackSize AS INT,
                  @Weight AS INT,
                  @Dimensions AS varchar(100),
                  @Length AS INT,
                  @Width AS INT,
                  @Height AS INT,
                  @Country AS varchar(100),
                  @Comment AS varchar(200)



DECLARE main CURSOR FOR



SELECT

      SkuID,

      SkuCode,

      SkuName,

      PackSize,

      Weight,

      Dimensions,

      Country,

      Comment

FROM RefSku



BEGIN TRAN



OPEN main

FETCH NEXT FROM main

INTO @SkuID, @SkuCode, @Skuname, @PackSize, @Weight, @Dimensions, @Country, @Comment



WHILE @@FETCH_STATUS = 0

      BEGIN


--Тут какие-либо действия с полученными ячейками строки----------

            FETCH NEXT FROM main

            INTO @SkuID, @SkuCode, @Skuname, @PackSize, @Weight, @Dimensions, @Country, @Comment



            IF @@ERROR<>0 ROLLBACK TRAN

      END





CLOSE main

DEALLOCATE main

COMMIT TRAN