Is there any better way to write the lines below in SQL Server 2005?
CASE WHEN (ID IS NULL) THEN 'YES' WHEN (ID IS NOT NULL) THEN 'NO' END AS ID_Value,
migrated from serverfault.com Jul 11 '12 at 2:49
This question came from our site for system and network administrators.
Did you try:
I only have access to 2008 right now, but I'd hope that this syntax would still work in 2005 (seems like something that would be part of the original definition of