Answer / vandana chand

Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.

Answer / sankar

1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.

2)We can call Trigger inside the store procedure. But
reverse is not possible.

What is a NOLOCK?

3 Answers   NA,

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

what is dbcc? : Sql server database administration

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

What do you understand by the analysis services in sql server?

0 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

select empid empname from employee What is the result for the about query?

4 Answers  

---