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
- 6510 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the xml datatype?
What are the general features of sql server management studio? : sql server management studio
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain the truncate command? : SQL Server Architecture
How do I save a stored procedure in sql server?
What is an indexing strategy?
What is the difference between mysql and sql server?
what is dbcc? : Sql server database administration
How to make a remote connection in a database?
What is bcnf normalization form?
is there a column to which a default can't be bound? : Sql server database administration
Explain external key management in sql server 2008
what kind of lan types do you know? : Sql server database administration
What is open database communication (odbc)?
What is the purpose of sql profiler in sql server? : sql server database administration
