阅读背景:

当查询没有返回任何行时,返回至少X行(空行直到行数为X)

来源:互联网 

is there a way to get at least X rows? Even when the query returns 0 rows. Example, if a table has 3 rows total, how can i do a SELECT TOP 10 from that table and return 3 rows that has data in it and 7 rows that are all nulls?is there a way to get at least X rows? Even whe




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

分享到: