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 are the different types of cursor?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is the default server name for sql server?
What is precedence constraint?
Can you please explain the difference between primary keys and foreign keys?
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?
Is the order of columns in the set clause important in ms sql server?
How to get the definition of a stored procedure back?
How is sql used in sql server?
How do I start and stop sql server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How will you monitor replication latency in transactional replication? : sql server replication
What is attribute hierarchy? : sql server analysis services, ssas
How to write a query with a left outer join in ms sql server?
What is the usage of sign function?