Differences

This shows you the differences between two versions of the page.

sql-server:ansi_nulls [December 14, 2011 4:24 am]
sqlines
sql-server:ansi_nulls [December 14, 2011 4:28 am] (current)
sqlines
Line 7: Line 7:
| **Default** | ON since SQL Server 2008 | OFF in earlier versions | | **Default** | ON since SQL Server 2008 | OFF in earlier versions |
| **Note** | SET ANSI_DEFAULTS ON/OFF automatically sets ANSI_NULLS ON/OFF || | **Note** | SET ANSI_DEFAULTS ON/OFF automatically sets ANSI_NULLS ON/OFF ||
-| **Get Current Value** | Execute //SELECT SESSIONPROPERTY('ANSI_NULLS')// or //DBCC USEROPTIONS// ||+| **Get Current** | Execute //SELECT SESSIONPROPERTY('ANSI_NULLS')// or //DBCC USEROPTIONS// ||
**Versions**: Microsoft SQL Server 2008 R2 **Versions**: Microsoft SQL Server 2008 R2