SQL Server Ansi_null_default | ansi_null_dflt_on

Let's start by saying that these two variables are a meaning, but their scope is different.

ALTER DATABASE dbTest set ANSI_NULL_DEFAULT on; -This is scoped to the entire SQL Server database!

Set set ANSI_NULL_DFLT_ON on; -The scope of this is the current connection!

* * Note that the names of these two variables are not the same!

Example:

1:create database dbTest;

2:alter database dbTest set ansi_null_default_on off;

3:create table t (x int, y int);

4:insert into t (x, Y) VALUES (null,null); --Because the 2nd step sets the option to off so there will be an error here!

　　　　　

　　

　　

SQL Server Ansi_null_default | ansi_null_dflt_on