Hi,
Can anybody let me know that what does SET ANSI NULLS ON do .
Thanks, Chris
The very first result in a Google search for SET ANSI NULLS ON. You'd think it'd be quicker to search for it than post a question here.
Matt Hamilton
2009-01-04 23:05:28
That's exactly how I found it myself. :D
le dorfier
2009-01-04 23:06:47
This answer shouldn't be up-voted, until it's fixed - it shouldn't just link to the information, it should also quote it. Isn't it the point of SO?
Paulius Maruška
2009-01-04 23:07:50
I agree in principle, Paulius, and haven't up-voted it myself, but when someone asks a question that can be so well documented and easily found on Google, I dunno that it's necessary to duplicate the answer here.
Matt Hamilton
2009-01-04 23:17:44
@Matt: unless the resource linked to goes away. Not likely in the case of MSDN, but in other cases maybe. I usually try to write answers as stand-alone, and use links for further reading or as supportive documentation.
Bill Karwin
2009-01-04 23:44:26
I see no reason why an informative post shouldn't be upvoted just because it's a link.
ceejayoz
2009-01-04 23:46:02
I'm not in it for points anyway, so whatever. This OP has been registered for a week and the only activity has been 5 no-brainer questions like this. Yes, I checked first. I was not inclined to give it any more effort than OP did.
le dorfier
2009-01-04 23:52:03
+6
A:
It changes the way NULLs behave. NULLs in ANSI yield things like
NULL = NULL -> false
NULL <> NULL -> false
With ANSI off, (NULL = NULL) -> true.
Otávio Décio
2009-01-04 23:04:06