SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
SQL-DMO Reference
Properties (SQL-DMO)
C (SQL-DMO Properties)
CaseSensitive Property
Catalog Property
Category Property
CentralizedConflicts Property
CharacterSet Property
Checked Property
CheckPermissions Property
Clustered Property
CmdExecSuccessCode Property
CodePage Property
Collation Property
CollationName Property
ColumnDelimiter Property
ColumnMaxLength Property
ColumnName Property
Columns Property
ColumnsNullByDefault Property
ColumnTracking Property
ColumnType Property
Command Property
CommandOptions Property
CommandTerminator Property
CompareNull Property
CompatibilityLevel Property (Database)
CompatibilityLevel Property (MergePublication2, TransPublication2)
ComputedText Property
ConflictPolicy Property
ConflictRetention Property
ConflictTable Property
ConnectionID Property
ConnectTimeout Property
ContactNull Property
CopyAllDefaults Property
CopyAllFunctions Property
CopyAllObjects Property
CopyAllRules Property
CopyAllStoredProcedures Property
CopyAllTables Property
CopyAllTriggers Property
CopyAllUserDefinedDatatypes Property
CopyAllViews Property
CopyData Property
CopySchema Property
CountResetDate Property
CreateDate Property
CreateForAttach Property
CreationScriptOptions Property
CreationScriptPath Property
CurrentCompatibility Property
CurrentExecutionStatus Property
CurrentResultSet Property
CurrentRunRetryAttempt Property
CurrentRunStatus Property
CurrentRunStep Property
CurrentValue Property
CursorCloseOnCommit Property
Count Property
CountResetTime Property (SQL-DMO)
Expand Minimize
This topic has not yet been rated - Rate this topic

ContactNull Property

SQL Server 2008

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ContactNull property specifies NULL-value handling for catenation.

Copy 
object.ContactNull [=value]
object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

Copy 
HRESULT GetContactNull(LPBOOL pRetVal);
HRESULT SetContactNull(BOOL NewValue);

If TRUE, A + NULL, where A is a string, yields NULL.

If FALSE, A + NULL, where A is a string, yields A.

Any value for ContactNull is overridden by the AnsiNulls property, which controls NULL catenation behavior for a client session.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.