Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

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

0 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What is sql server management studio? : sql server management studio

0 Answers  

---

What are the dmvs?

0 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---