Interested to Buy Any Domain ? << Click Here >> for more details...
What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 6345 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
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 do you mean by an execution plan? Why is it used?
What are cascading parameters in ssrs reports?
What are the different types of sub-queries?
what is package and it uses and how can u call a package
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Define self join?
What is the difference in accessing db between sql server vs sql azure?
What is the Main Difference between ACCESS and SQL SERVER?
What information is maintained within the msdb database?
What is the purpose of a table?
Can we call stored procedure in view in sql server?
Please illustrate physical database architecture? : SQL Server Architecture
Write a program to fetch first 10 records from a file?
What is the difference between a function and a stored procedure?
How many databases instances are there in sql server 2000?
