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
Why we need sql server?
How to create new table with "create table" statements?
How to change server name in sql server?
What is the sql case statement used for?
What are the parts of a function?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to remove duplicate rows from table except one?
How to delete duplicate records based on single column from a table?
What authentication modes does sql server support?
Relational calculus is what type of language?
What it means to be triggered?
How do I view a script in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are temporal tables in sql server 2016?
What do you mean by an execution plan? Why is it used?