What are the difference between data length and length in
SQL Server-2008?
Answer Posted / bindu
The DATALENGTH function counts both trailing spaces and preceeding spaces when calculating the length of the expression.
The DATALENGTH function will return NULL, if the expression is NULL.
The LEN function does NOT count trailing spaces at the end of the string when calculating the length of the string.
The LEN function does count spaces at the start of the string when calculating the length of the string.
The LEN function will return NULL, if the string is NULL.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a periodical index?
what is difference between view and Dip.
What is the difference between having clause and where clause in sql server?
What is cursor in ms sql server?
Please illustrate physical database architecture? : SQL Server Architecture
Explain throw statement in sql server 2008?
What is a schema in ms sql server 2005?
What is acid mean in sql server?
How can I change procedure name in sql server?
What is the language structure to add a record to a table?
Which are ddl commands?
What is 2nf normalization?
define and explain the differences between clustered and non-clustered indexes.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are the disadvantages of primary key and foreign key in SQL?