June 4, 2013 at 10:52 pm
Comments posted to this topic are about the item Usage of Null
June 4, 2013 at 11:12 pm
An easy one for the day.
SET ANSI_NULLS ON --> enforces SQL-92 standard which says that all equal to and not equal to with NULL evaluates to FALSE.
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
June 4, 2013 at 11:36 pm
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
June 5, 2013 at 12:16 am
Danny Ocean (6/4/2013)
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D
+1
I also observed the same 🙂
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
June 5, 2013 at 1:49 am
Starting from SQL2000 SET ANSI_NULLS OFF is a real deprecated option.
From BOL:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
June 5, 2013 at 3:03 am
Carlo Romagnano (6/5/2013)
Starting from SQL2000 SET ANSI_NULLS OFF is a real deprecated option.From BOL:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
+1. nice and easy question....
Manik
You cannot get to the top by sitting on your bottom.
June 5, 2013 at 3:24 am
It was too easy. The first statement let choose the correct answer.
June 5, 2013 at 4:19 am
This was removed by the editor as SPAM
June 5, 2013 at 4:52 am
Easy one for the day 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 4:53 am
Danny Ocean (6/4/2013)
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D
Right, only one option available so didn't required to read the all options 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 7:07 am
Lokesh Vij (6/4/2013)
An easy one for the day.SET ANSI_NULLS ON --> enforces SQL-92 standard which says that all equal to and not equal to with NULL evaluates to FALSE.
I think technically it evaluates to "UNKNOWN"
http://msdn.microsoft.com/en-us/library/ms191270(v=sql.105).aspx.
June 5, 2013 at 7:19 am
Danny Ocean (6/4/2013)
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D
+1
Very easy one today 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 5, 2013 at 7:48 am
All,
Yes easy, but helpful. We are in the process of converting a whole mess of 10-15 year old Access/SQL Server applications and we are finding some "@Var = NULL" buried in some of the old stored procedures causing some interesting side effects.
It is interesting to see how coding practices and technology change over the years. This application also has a ton of triggers implementing RI, user defined error messages (which were never brought forward when we moved the databases to a new server), identity columns defined by a separate table that is incremented when a new row is inserted as well as some interesting database designs.
Anton
June 5, 2013 at 9:34 am
Danny Ocean (6/4/2013)
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D
Yup - very easy
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 5, 2013 at 9:40 am
Koen Verbeeck (6/5/2013)
Danny Ocean (6/4/2013)
Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to read complete question.:-D+1
Very easy one today 😀
+1 😀
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply