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 sql server profiler trace data file?
What are different replication agents and what's their purpose? : sql server replication
How do you know if sql server is running on your local system?
What are the common performance issues in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
Explain “row_number()” in sql server with an example?
What are the triggers in sql?
What is resource governor in sql server?
What are constraints in microsoft sql server?
How to transfer data from a cursor to variables with a "fetch" statement?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is buffer cash in sql server?
Explain primary key and foreign key constraints?
How would you add a section to a table?
What is the purpose of a table?