How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

How to create Clustered Primary Key to table?

2 Answers  

---

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

---

What is trigger explain with program?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Why and when do stored procedure recompile?

0 Answers  

---

How to create indexed view?

0 Answers  

---

What is merge join?

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---