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 sql server procedures?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are triggers? How do you invoke a trigger on demand?
plss anybody specify tha constrian management system in dbms
How to rebuild all indexes on a single table?
Can I work with several databases simultaneously? : sql server management studio
List the different types of joins?
What are the types of ssrs?
How to see the event list of an existing trigger using sys.trigger_events?
What is the difference between join and inner join?
How adventureworkslt tables are related?
can a table be moved to different filegroup? : Sql server administration
What is extended stored procedures?
What are the five major components of a dbms?
Explain database normalization?