Usage of Null

Question

Usage of Null

Bhavpreet Singh Narang

SSC Enthusiast

Points: 136
More actions
June 4, 2013 at 10:52 pm

#294143

Comments posted to this topic are about the item Usage of Null
Regards,
Bhav
SSISDevelopers.wordpress.com[/url]
June 5, 2013 at 4:19 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

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

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

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 !!!

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

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

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Carlo Romagnano SSC-Insane Points: 22597 More actions · Answer 4

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.

manik_anu SSCrazy Points: 2377 More actions · Answer 5

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.

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 6

It was too easy. The first statement let choose the correct answer.

kapil_kk SSC-Insane Points: 21316 More actions · Answer 7

Easy one for the day 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

kapil_kk SSC-Insane Points: 21316 More actions · Answer 8

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/

sestell1 SSChampion Points: 10230 More actions · Answer 9

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.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 10

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

aochss SSCommitted Points: 1677 More actions · Answer 11

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

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

Revenant SSC-Forever Points: 42467 More actions · Answer 13

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 😀