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

Define compound operators?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

How to disable stored procedure sql server?

0 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

How do you delete duplicate rows in sql server?

0 Answers  

---

---

How to create and drop temp table in sql server?

0 Answers  

---

What is collation sensitivity? Explain different types.

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---