您现在的位置是:首页 > SQLServer

SQLServer

update top(1)

2020-11-21 11:29:44 SQLServer admin
with w_Hr_CostHistory as (select top 1 * from Hr_CostHistory where DateDiff(s,BeginDate,@BegindDate)>0 and SID=@SID orde

with w_Hr_CostHistory as (select top 1 * from Hr_CostHistory where DateDiff(s,BeginDate,@BegindDate)>0 and SID=@SID order by ID Desc)
update w_Hr_CostHistory set Cost=@Cost,Updater=@Updater