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
很赞哦! ()
- 上一篇: 多表部分对应列联合查询(重要)
- 下一篇: 返回列表