Search notes:

SQL Server: set ansi_warnings

Heterogenous queries

Heterogenous queries require the setting of ansi_warnings (as well as that of ansi_nulls) to be set to on.

See also

TODO: Null value is eliminated by an aggregate or other SET operation
The T-SQL set statement

Index