Answer / sapthagiri

LEN
Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.

DATALENGTH
Returns the number of bytes used to represent any expression.

Answer / 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.

Answer / 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.

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

What are partitioned views?

0 Answers  

---

How do you make a trace?

0 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

What do you know about system database? : SQL Server Architecture

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---