What are the difference between data length and length in
SQL Server-2008?
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 view in sql?
What are security principals used in sql server 2005?
What is a bit datatype?
What are logical database components? : SQL Server Architecture
Which is faster statement or preparedstatement?
Explain “@@rowcount” and “@@error” in sql server?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is subquery explain with example?
Is ssrs support other database except ms sql server?
What is buffer cash in sql server?
What is the security principal at the server level that represents your session?
How do I make a resultset scrollable?
What is ms sql server reporting services?
What will happen if a column containing char type data is changed to the nchar data type?
What do you know about system database? : SQL Server Architecture