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
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
List types of tables in SQL Azure?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is the difference between set and select?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What methods do you follow to protect from sql injection attack?
How to encrypt data between dialogs?
How to disable stored procedure sql server?
Name 3 ways to get an accurate count of the number of records in a table?
Disadvantages of the indexes?
what is a correlated sub-query? : Sql server database administration
What does the update command do?
How can windows applications connect to sql servers via odbc?
What is the cartesian product of table?
What is the size of transaction log file?