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.

How to fetch the next row from a cursor with a "fetch" statement?

1 Answers  

---

What is instead of trigger sql server?

1 Answers  

---

Explain for xml explicit mode?

1 Answers  

---

How do I know if localdb is running?

1 Answers  

---

tell me the disaster recovery plan

1 Answers   Microsoft,

---

What is the difference between having and where clause?

4 Answers  

---

What is the difference between a unique key and primary key?

1 Answers  

---

What is indexing in sql server with example?

1 Answers  

---

What is resource governor?

1 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

1 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

What is data source object?

1 Answers  

---