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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2005-01-12 : 09:36:00
|
| Hello all, I moved a dabase from SQL 6.5 to SQL 2000. By default Ansi_nulls is set to ON in 2000. I read books online before posting this thread about Ansi_Nulls. Will there be any issues if i set ansi_nulls to OFF? I under stand that if i set it to OFF, = NULL willwork and will not work if its set to ON. Will there be any issues? Can we set Ansi_Nulls at table level?Thanks,Rick |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-12 : 10:55:40
|
| >> Will there be any issues?Probably - you can only tell by testing.>> Can we set Ansi_Nulls at table level?No - only for the seession.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-12 : 11:22:15
|
| I strongly recommend against changing the ANSI_NULLS setting -- deal with the nulls explicitly in your T-SQL, using COALESCE as needed.- Jeff |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2005-01-12 : 11:44:59
|
| Thanks Guys!!!If i do exec sp_dboption 'Database_Name', 'ANSI null default','True'andexec sp_dboption 'Database_Name', 'ANSI nulls', 'false'This is at database level.so, when ever i query a table with nulls. I can use where column_name = NULL and where column_name IS NULL because ANSI NULLS is set to FALSE. |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2005-01-14 : 15:51:11
|
| Can we set ANSI_DEFAULTS OFF at database level?Or is there any other options we can set? |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-14 : 16:43:29
|
| I strongly recommend against changing the ANSI_NULLS setting -- deal with the nulls explicitly in your T-SQL, using COALESCE as needed.- Jeff |
|
|
|
|
|
|
SET ANSI_NULLS OFF