Export (0) Print
Expand All

AnsiPaddingStatus Property

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 AnsiPaddingStatus property returns TRUE if the referenced column is defined to exhibit SQL-92 character padding behavior.


object
.AnsiPaddingStatus

object

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

Boolean

Read-only

HRESULT GetAnsiPaddingStatus(LPBOOL pRetVal);

By default, Microsoft SQL Server trims trailing blanks, or null bytes, from variable-length character or binary column data when values are inserted. The SQL-92 standard requires trailing blanks and null bytes are not trimmed as data is inserted.

Community Additions

ADD
Show:
© 2015 Microsoft