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

What is compound operators?

0 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

What is always encrypted?

0 Answers  

---

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

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

How do I connect to sql server database?

0 Answers  

---