[<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 name not found and no default driver specified [ODBC SQL Server Driver] Invalid Parameter...
I guess it might cause a problem on Monday 8 July when the real question for that day turns up. Anyway, the same question being listed for two days several weeks apart (3rd June and 8 July) does suggest that there's something a bit silly in the schema design for the data about QotD...
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...
"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 ...
“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...
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...