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
- 6190 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 list all tables in the database using odbc_tables()?
In what three ways is the return statement used in a stored procedure?
What is RAID? What are the different types of RAID configurations?
What is difference between delete and truncate commands?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What do you mean by an execution plan? Why is it used? How would you view it?
How to rename databases in ms sql server?
What does null mean?
What is proper subset of candidate key?
Is foreign key unique?
What is subreport?
Can you move the resources after pausing the node? : sql server database administration
Explain about remote stored procedure?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
