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,
|show 2 more comments|
This question came from our site for professional 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