What is use of except clause? How it differs from not in clause?

0 Answers  

---

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  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What is clr ddl trigger?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---