What are the difference between data length and length in
SQL Server-2008?
Answer Posted / sapthagiri
LEN
Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.
DATALENGTH
Returns the number of bytes used to represent any expression.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is data source document?
Can we use where and having clause together?
What are cursors and when they are useful?
Do you know query execution plan?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
can you instantiate a com object by using t-sql? : Sql server database administration
How to create function without parameter in sql server?
What is subquery in sql?
when you create a database how is it stored? : Sql server database administration
What are the advantages to use stored procedures?
What are the steps you should follow to start sql server in single-user mode?
what is a deadlock? : Sql server database administration
what is the primary use of the model database? : Sql server administration
How use inner join in sql server?