阅读背景:

是否可以将列列表传递到merge语句中的值构造函数中?

来源:互联网 

I tried to find a way to pass a column list into values constructor in merge statement. Any idea? The reason is we have a lot of source tables and want to update target table for each of source tables by using merge. If merge statement find not matched, inserting to target should be choose. However, in this insert statement, it ask for a column list of source. That means I have to list each of column of source table. It is so tedious for each table that I am wondering if any way to pass it as a parameter. Appreciate for any idea.I tried to find a way to pass a column list int




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: