Union All and returnmodel properties

[tbjerknes]

When Union All is used in a query, the properties in the resulting return model are always of the nullable type. Here is a simple example i used:

Returnmodels for the two procs:

I am not sure this should be counted as an issue, but I just thought I would mention it.

[sjh37]

Thanks for the info. SQL Server tells me what the return columns are for each stored procedure. Not sure why it did that given the return columns are all NOT NULL. Very odd.

There is nothing I can do about it either as I have to accept the exact types returned to me. So I'll have to close this issue, but is an interesting facet of SQL Server.

[tbjerknes]

Hi Simon, thanks for the reply. I did a bit of digging and from Sql Server 2012 you can use this query to get metadata:

this query correctly identifies both proc results as non-nullable

It doesnt't work for multiple query results though.

Thomas

[sjh37]

Thanks Thomas