Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asuni
Yak Posting Veteran
55 Posts |
 Posted - 2010-05-21 : 02:57:31
|
Hi All,Starting for my database ANSI_NULLS is OFF. so, when i run the query with IS NULL no records are fetching.So later i put ANSI_NULLS is ON. and inserted few more records and run the select query with IS NULL. Then the latest records only fetching (entered the records after setting ANSI_NULLS is ON ).so, for existing data who to make the ANSI_NULLS property to apply.Any help please.  thanks |
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2010-05-21 : 10:50:39
|
| Try [Column] = NULL instead of [Column] IS NULLotherwise, put this before your query:set ANSI_NULLS OFF;and then try [Column] = NULL |
 |
|
|
|
|
|
ANSI_NULLS