Procedure Loop For Update

BEGIN

DECLARE @SAPHINMEICD VARCHAR(20);
DECLARE @NEWHINMEICD VARCHAR(20);
DECLARE @UPCOUNT INT ;

DECLARE curSekDt CURSOR FOR
SELECT
[SAPHINMEICD]
,[NEWHINMEICD]
FROM [dbo].[M_HINMEI_ERA]

SET @UPCOUNT = 0
OPEN curSekDt
-- FETCH
FETCH NEXT FROM curSekDt INTO
@SAPHINMEICD,
@NEWHINMEICD
WHILE @@FETCH_STATUS = 0

BEGIN
UPDATE [M_HINMEI] SET TOKUHINMCD = @SAPHINMEICD
WHERE TOKUHINMCD = @NEWHINMEICD;


SET @UPCOUNT =@UPCOUNT + 1

PRINT CAST(@UPCOUNT AS VARCHAR) + ': ' + @NEWHINMEICD + ' ⇒ ' + @SAPHINMEICD
+ '('+ CAST(@@ROWCOUNT AS VARCHAR) + ')'

FETCH NEXT FROM curSekDt INTO
@SAPHINMEICD,
@NEWHINMEICD
END
CLOSE curSekDt
DEALLOCATE curSekDt
END

posted @ 2016-12-27 14:15  tomclock  阅读(140)  评论(0编辑  收藏  举报