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 maximum rows in sql server table?

0 Answers  

---

What is normalization?

9 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What stored by the msdb? : sql server database administration

0 Answers  

---

What does select 1 mean?

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What do mean by xml datatype?

0 Answers  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---