阅读背景:

外部应用在不匹配时意外地返回列NOT NULL

来源:互联网 

I'm hitting some weird behavior on a table valued function when used with OUTER APPLY. I have a simple inline function that returns some simple calculations based on a row in another table. When the input values for the TVF are hard-coded scalars, there is no row returned. When I take the same scalars and make a single row out of them in a CTE, then feed them in as columns using CROSS APPLY, no result set. When I do the same with OUTER APPLY, I get 1 row (as expected), but two of the output columns are I'm hitting some weird behavior on a table valu




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

分享到: