What is trigger ?

7 Answers   Cap Gemini, SQL,

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What are the restrictions that views have to follow?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

Which is better statement or preparedstatement?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---