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
- 6513 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
Answer Posted / bindu
The DATALENGTH function counts both trailing spaces and preceeding spaces when calculating the length of the expression.
The DATALENGTH function will return NULL, if the expression is NULL.
The LEN function does NOT count trailing spaces at the end of the string when calculating the length of the string.
The LEN function does count spaces at the start of the string when calculating the length of the string.
The LEN function will return NULL, if the string is NULL.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to reaname table name without using sp_Rename in sql server..?
How to create “dependant” parameter “make, model, year”
How to connect to a sql server using odbc_connect()?
What is primary key index?
What are types of scd? : sql server analysis services, ssas
Why use view instead of a table?
How can a user-defined datatype be created?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Explain transaction server consistency?
What is etl - extraction, transformation, and loading?
What is the xml datatype?
When would you use sql joins?
What are the export options of ssrs?
What is the datatype of rowid?
Explain the difference between cross join and full outer join?
