SQL Server(T-sql)更新表从底部到顶部 [英] SQL Server(T-sql) Update table from botom to top

问题描述

im试图从下到上更新表temp(F4)结果.是while循环的每一行和更新是否可以按顺序排序?

im trying to update table temp(F4) result from bottom to top. Is it while-loop every row and update can be order by?

谢谢！

推荐答案

假设 ROW 是一个正整数，则可以使用(演示)

Assuming ROW is a positive integer then you can use (demo)

WITH T1 AS
(
SELECT *, 
       MIN(CASE WHEN F4 <> 0 THEN CONCAT(FORMAT([ROW],'D10'),[F4]) END) 
         OVER (ORDER BY [ROW] ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS M
FROM temp

)
SELECT *, 
       CAST(SUBSTRING(M,11,11) AS INT) AS val
FROM T1
ORDER BY [ROW]

如果要更新 F4 ，可以使用

WITH T1 AS
(
SELECT *, 
      MIN(CASE WHEN F4 <> 0 THEN CONCAT(FORMAT([ROW],'D10'),[F4]) END) 
           OVER (ORDER BY [ROW] ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS M
FROM temp

)
UPDATE T1
SET F4 = COALESCE(SUBSTRING(M,11,11),0);

这篇关于SQL Server(T-sql)更新表从底部到顶部的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！