what is a cursor and what is its use?

2 Answers   L&T,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What is trigger explain with program?

0 Answers  

---

What is xml datatype?

0 Answers  

---

What is sql view?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How to delete a database in ms sql server?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

How does a profiler work?

0 Answers  

---