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.

Why it is recommended to avoid referencing a floating point column in the where clause?

959

---

how many triggers you can have on a table? : Sql server database administration

974

---

When would you use sql joins?

956

---

How do I debug a stored procedure in sql server?

1102

---

Define indexes?

1037

---

What is database dimension? : sql server analysis services, ssas

1077

---

whats new about truncate in sql server 2008?

2497

---

List out the difference between union and union all in sql server?

988

---

Can we install sql server 2016 on windows 7?

1130

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1507

---

How can you list all the columns in a database?

924

---

Can a table have 2 foreign keys?

905

---

How to write a query with a full outer join in ms sql server?

1071

---

What is read uncmmited?

1053

---

What are the advantages of user defined function?

981

---