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 the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

what is a deadlock? : Sql server database administration

0 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

What are entities and relationships?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

Define Joins?

0 Answers   HCL,

---

Explain “not null constraint” in sql server?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---