ANSI_PADDING can be set ON or OFF. It controls the way column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks in char, varchar, binary, and varbinary data.
Transact SQL Statement to set it ON
SET ANSI_PADDING ON
Transact SQL Statement to set it OFF
SET ANSI_PADDING OFF
ANSI_PADDING setting is ON :
char(n) and binary(n) - Pads value with trailing blanks for char columns and with trailing zeros for binary columns to the length of column.
varchar(n) or varbinary(n) - Trailing blanks in varchar are not trimmed . Trailing zeroes in varbinary are not trimmed. Does not pads trailing blanks or zeroes to the length of column.
ANSI_PADDING setting is OFF :
char(n) and binary(n) - Pads value with trailing blanks for char columns and with trailing zeros for binary columns to the length of column.
varchar(n) or varbinary(n) - Trailing blanks in varchar are trimmed . Trailing zeroes in varbinary are trimmed. Does not pads trailing blanks or zeroes to the length of column.
Popular Posts
-
RegisterStartUpScript This adds the javascript code at the end of the page before the closing of form tag. RegisterClientScriptBlock Th...
-
delegate string Delegate1(object o); delegate object Delegate2(string s); static string Dispaly(object o) { r...
-
@@ERROR is a global variable used to return error number of last T-SQL.
-
Please follow below steps to enable transaction in Web Service : 1.Add a reference to System.EnterpriseServices.dll. 2.Add the System.Ente...
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
window.open
-
To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All inform...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
The WebMethod attribute in Web Service provides the following properties: BufferResponse CacheDuration Description EnableSession Messa...
-
Computed Column is virtual column in table whose value is computed at runtime.The values are not stored in table but computed by the express...
Posts
No comments:
Post a Comment