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

A trigger can reference objects outside the current database? State true or false.

0 Answers  

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

What are cursors in ms sql server?

0 Answers  

---

Is resultset an interface?

0 Answers  

---

How do I setup a sql server database?

0 Answers  

---

What does it mean to normalize data?

0 Answers  

---

What is user-defined inline table-valued function?

0 Answers  

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What stored procedure would you use to view lock information?

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---