UPDATE MyTable SET lastdate = CASE ISNULL(date,'') WHEN '' THEN lastdate ELSE date END,
lasttime = CASE ISNULL(time,'') WHEN '' THEN lasttime ELSE time END
FROM (SELECT TOP 1 date,time FROM OtherTable ORDER BY date DESC,time DESC) AS A
SQL SERVER 连续两个desc 和 Update From 用法
最新推荐文章于 2024-08-20 16:14:35 发布