What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 5601 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
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
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are rest-style architecture's?
What is tablesample?
Does windows server 2016 come with sql server?
What is the need for indexing?
Tell me about the approaches which you used to counter the DI problems.
Are all views updatable ?
What stored by the msdb? : sql server database administration
What is scheduled job and how to create it?
How will you decide the active and passive nodes?
What does executeupdate return?
What is triggers in ms sql server?
How to list all dsn entries on your local machine using odbc_data_source()?
How to resolve the orphan use problem? : sql server security
Define tempdb database?
