如何在sqlserver中每天自动增加数量（列名） [英] how to increment amount(column name) automatically every day in sqlserver

问题描述

hi frnds ,
i am new to the sql server ,  please give me some suggestion
in sqlserver i have a two  coulmns like (amount and date ) every day amount should increment by  50 rupees . .please help  me guys , i am not getting how to do . . please 
thanks . .

推荐答案

尝试：

Try:

UPDATE t1.Amount = t2.Amount + 50
FROM TableName as t1 INNER JOIN TableName AS t2 ON t1.Key = t2.Key

这篇关于如何在sqlserver中每天自动增加数量（列名）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！