Interested to Buy Any Domain ? << Click Here >> for more details...
What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 6332 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bindu
The DATALENGTH function counts both trailing spaces and preceeding spaces when calculating the length of the expression.
The DATALENGTH function will return NULL, if the expression is NULL.
The LEN function does NOT count trailing spaces at the end of the string when calculating the length of the string.
The LEN function does count spaces at the start of the string when calculating the length of the string.
The LEN function will return NULL, if the string is NULL.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajkumar
If the string has the space before the like
select LEN(' raj')
select dataLENgth(' raj')
Both consider the space.
but space is after the string len is not bother about space it wil be trucated.
datalenth counted with space.
| Is This Answer Correct ? | 2 Yes | 0 No |
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Does index speed up select statements?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
How to test values returned by a subquery with the in operator?
How can I change procedure name in sql server?
Which autogrowth database setting is good?
How do I find the query plan in sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are system databases in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
What is a NOLOCK?
What are the different authentication modes in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
