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 is shrink log file?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Where are sql server user names and passwords stored in sql server?
Explain an automatic checkpoint
What is difference between Datepart() and Datename() in SqlServer?
How to execute stored procedure in select statement sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What happens if null values are involved in string operations?
How many columns can exist together per table?
How do I edit a stored procedure in sql server?
What are triggers in ms sql server?
What are the common performance issues in sql server?
What is 2nf normalization form?
What is enhanced database mirroring in sql server 2008?
How to get all stored procedures in sql server?