I'm working on converting a datbase currently in SQL 2000 over to SQL 2008 and found this peculiarity:
DECLARE @sql varchar(1)
SET @sql = NULL
On my SQL 2000 machine that code returns 0, but on my test box running SQL 2008 it returns 1 no matter the compatibility level of the database (80 or 100). Is there a global setting / flag that might affect this behavior? Or is it just
a design difference in the two engines?
I haven't turned up anything when searching elsewhere, hoping someone can shed some light.
View Complete Post