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
- 6352 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
How to add code to the existing article (using improve article)?
How to transfer a table from one schema to another?
Can You Use Data Mining Models In Ssrs?
What are the properties and different types of sub-queries?
Can we write trigger for view?
Will count(column) include columns with null values in its count?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Write an sql query to find first weekday of the month?
What are different types of table joins?
How can sql server instances be hidden? : sql server security
What is Command line parameters in PLSQL.?
What is a database table?
Is the order of columns in the set clause important in ms sql server?
Explain temporary table vs table variable by using cursor alternative?
What is the user of Primary key?
