This is clearly documented in Books Online, by the way. Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)Visit my SQL Server blog: https://sqlserverfast.com/blog/SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ Neeraj Prasad Sharma Ten Centuries Points: 1315 More ac...
Currently this feels like playing lottery to me, and that's something I truly hate in SQL Server. There must be rules, and I want to know and understand them. I don't understand this either. At one time I played with it and thought it might be that the result of coalesce is nullabl...
“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server [<Name of Missing Index, sysname,>] in non clustered index [Execute SQL Task] Error: The value type (__ComObject) can only be converted to variables of type Object. [ODBC Driver Manager] Data source nam...
This is because if your source is a database, you'll almost always have nullable columns in a database, meaning we will generate a tree with the coalesce node. Extension methods Before I close, I want to examine the case where you call the where operator in extension method format, ...
Don't forget that in SQL NULLs have type; a NULL value in an int column or for an int variable has type int, as of course does the constant expression cast(NULL as int). Back in January I had a QotD aiming to help people learn how typed nulls and coalesce interact:Coalesce and Con...
"explicit value must be specified for identity column in table" error in SQL 2000 "FROM clause have the same exposed names. Use correlation names to distinguish them" "No transaction is active." error when trying to send a transactional SQL statment over MSDTC "Restricted data type attribute ...