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
- 6185 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 is recompile sql server?
When does a workload on SQL Azure get throttled?
Which are the olap features?
Why is the need for data conversion transformations?
How to concatenate two character strings together?
What is the data tier application?
What is the order by used for?
What is Federation and Federation Member?
What are the difference between primary keys and foreign keys?
Explain the benefits of user-defined functions?
How would you choose between a clustered and a non-clustered index?
What are the components of dbms?
What is autocommit mode in sql server?
How to store and query spatial data?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
