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


Please Help Members By Posting Answers For Below Questions

Why we need sql server?

750


How to create new table with "create table" statements?

760


How to change server name in sql server?

847


What is the sql case statement used for?

793


What are the parts of a function?

712


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

905


How to remove duplicate rows from table except one?

772


How to delete duplicate records based on single column from a table?

815


What authentication modes does sql server support?

799


Relational calculus is what type of language?

814


What it means to be triggered?

696


How do I view a script in sql server?

764


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?

753


What are temporal tables in sql server 2016?

695


What do you mean by an execution plan? Why is it used?

779