有没有类似于“select(1,2,3) as source(id, line, row)”的语句,其中source不是表名,id、line、和row也是起的别名,为了方便后续通过source.id,source.line,source.row取值。
在merge into的时候需要用到。
收起merge into target
using (select 1, 25, 'XiaoLi' from systables where tabid=1) as source(id, age, name)
on target.id=source.id
when matched then
update set target.id=source.id, target.age=source.age, target.name=source.name
when not matched then
insert (target.id, target.age, target.name) values(source.id, source.age, source.name);