Sql server循环改值

 DROP TABLE #temp;

SELECT ID,ROW_NUMBER() OVER(ORDER BY DATE) AS row, REPLACE(NAME,'.pdf',RIGHT('0000'+CAST((ROW_NUMBER() OVER(ORDER BY DATE)) AS NVARCHAR(10)),4)+'.pdf') AS NAME
INTO #temp
FROM IMAGES
WHERE PARENT_ID='C84DF06E-498C-4F0E-8848-FEA3099E87B9'


 DECLARE @i INT;
 DECLARE @count INT;
 
 DECLARE @NAME NVARCHAR(500);
 DECLARE @ID UNIQUEIDENTIFIER;

 SET @i = 1;
 SELECT @count = COUNT(1)
 FROM   #temp;

 WHILE @i <= @count
    BEGIN
 
        SELECT  @ID = ID,@NAME=NAME
        FROM    #temp
        WHERE   row = @i;
        
       
        UPDATE  IMAGES
        SET     NAME = @NAME 
        WHERE   ID = @ID;

     
        SET @i = @i + 1;
    END;

　　

转载于:https://www.cnblogs.com/kangjing/p/8978830.html