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

where the connection string store in the database

0 Answers   HCL, Wipro,

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What is meant by indexing?

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---

What is data file in computer?

0 Answers  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

What do you mean by data integrity?

0 Answers  

---

What is index in an assignment?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---