What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 5340 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
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 happens if null values are involved in datetime operations?
How to sort the query output with order by clauses in ms sql server?
What is awe?
What are the different types of replication you can set up in sql server?
What is reportserver and reportservertempdb ?
How do you migrate data from mssql server to azure?
What is use of except clause?
How to create function without parameter in sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
what are user defined datatypes? : Sql server database administration
How do I clean up sql server transaction log?
Describe the left outer join & right outer join. : sql server database administration
Explain the microsoft sql server delete command?
Tell me what is normalization? Explain different forms of normalization?
How can I check if a view exists in a sql server database?
