GETANSINULL (Transact-SQL)
Returns the default nullability for the database for this session.
.gif "Ikona łącza do tematu")
Transact-SQL Syntax Conventions
Składnia
GETANSINULL ( [ 'database' ] )
Arguments
- 'database'
Is the name of the database for which to return nullability information. databaseis either char or nchar. If char, database is implicitly converted to nchar.
Return Types
int
Uwagi
When the nullability of the specified database allows for null values and the column or data type nullability is not explicitly defined, GETANSINULL returns 1. This is the ANSI NULL default.
To enable the ANSI NULL default behavior, one of these conditions must be set:
ALTER DATABASE database_name SET ANSI_NULL_DEFAULT ON
SET ANSI_NULL_DFLT_ON ON
SET ANSI_NULL_DFLT_OFF OFF
Examples
The following example returns the default nullability for the AdventureWorks2012 database.
USE AdventureWorks2012;
GO
SELECT GETANSINULL('AdventureWorks2012')
GO
Here is the result set.
------
1
(1 row(s) affected)