Shulou(Shulou.com)06/02 Report--

This article introduces you how to understand the use of Ansi_Padding, the content is very detailed, interested friends can refer to, I hope it can be helpful to you.

If you know anything about the use of Ansi_Padding, let me share with you that when set to OFF, the trailing spaces of the varchar column and the trailing zeros of the varbinary column are clipped. This setting affects only the definition of the new column.

About the usage of Ansi_Padding

When set to ON, trailing zeros inserted into varchar columns in trailing spaces and binary values in character values are not clipped. Values are not populated by the length of the column. When set to OFF, trim the trailing spaces of the varchar column and the trailing zeros of the varbinary column. This setting affects only the definition of the new column.

When SETANSI_PADDING is ON, the Char (n) and binary (n) columns that allow null values are populated to the column length, while when SETANSI_PADDING is OFF, trailing spaces and zeros are clipped. Char (n) and binary (n) columns that do not allow null values are always populated to the column length.

Sample code:

SETANSI_PADDINGON GO PRINT'TestingwithANSI_PADDINGON' GO CREATETABLEt1 (charcolchar (16) NULL, varcharcolvarchar (16) NULL, varbinarycolvarbinary (8) GO INSERTINTOt1VALUES ('Noblanks','Noblanks',0x00ee) INSERTINTOt1VALUES (' Trailingblank','Trailingblank',0x00ee00) SELECT'CHAR'=' >'+ charcol+''+varcharcol+''+charcol+''+varcharcol+'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.