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

What are the different types of cursor?

847


what's the difference between delete table and truncate table commands? : Sql server database administration

700


What is the default server name for sql server?

838


What is precedence constraint?

739


Can you please explain the difference between primary keys and foreign keys?

876


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1758


Is the order of columns in the set clause important in ms sql server?

739


How to get the definition of a stored procedure back?

725


How is sql used in sql server?

693


How do I start and stop sql server?

738


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

784


How will you monitor replication latency in transactional replication? : sql server replication

842


What is attribute hierarchy? : sql server analysis services, ssas

754


How to write a query with a left outer join in ms sql server?

778


What is the usage of sign function?

806