Answer / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Answer / sivasiva

Triggers:
Triggers create event that event pass the value for
insert,update delete automatically updated value for the
table.triggers are event driven sepecified procedure.store
and managed by DBMS.automatically fires the value.

Store procedure:
Fast Accesing.Reduse network traffic.sepatre businees rules
and logic from presentation layer

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

What are magic tables in sql server?

0 Answers  

---

What is key set driven?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What is 2nf normalization?

0 Answers  

---

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

What do you understand by replication in sql server?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---