|
Home > Archive > MS SQL Server > March 2006 > SET ANSI_NULLS ON?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SET ANSI_NULLS ON?
|
|
| Jason Huang 2006-03-27, 3:23 am |
| Hi,
When I want to alter an existing stored procedure.
The edit screen will have an "SET ANSI_NULLS ON".
What is that all about?
Thanks for help.
Jason
| |
| Ben Nevarez 2006-03-27, 3:23 am |
|
It defines the behavior of the comparison of null values (if it is SQL-92
compliant). For more detail and examples please look at BOL for
SET ANSI_NULLS
NULL Comparison Search Conditions
Ben Nevarez, MCDBA, OCP
Database Administrator
"Jason Huang" wrote:
> Hi,
>
> When I want to alter an existing stored procedure.
> The edit screen will have an "SET ANSI_NULLS ON".
> What is that all about?
> Thanks for help.
>
>
> Jason
>
>
>
| |
| littlekendra@gmail.com 2006-03-27, 3:23 am |
| This article by Ken Henderson gives a great explanation with samples:
http://www.awprofessional.com/artic...8&seqNum=8&rl=1
Basically, when you ansi_nulls is off, you can successfully compare a
null value with null values in a table. When ansi_nulls is on, the
comparison results in an uknown, and records won't be returned.
kl
| |
| Roji. P. Thomas 2006-03-27, 7:25 am |
| The current setting of the ANSI_NULLS and QUOTED_IDENTIFIER will be saved
with the procedure and will be used when you execute the procedure.
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:OoeQilUUGHA.2444@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> When I want to alter an existing stored procedure.
> The edit screen will have an "SET ANSI_NULLS ON".
> What is that all about?
> Thanks for help.
>
>
> Jason
>
>
|
|
|
|
|