Answer / m.ramarathna

Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.


when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .

Answer / sanjay kumar dinda

Trigger is a procedure which is invoked automatically when
any DML operation occured on a table.

At the time of DML operation , inside trigger SQL provide
the dummy table ( inderted , deleted) , which stores the
errected rows....

Where can you find the error log information? : sql server database administration

0 Answers  

---

What is transaction server isolation?

0 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

Explain use of expression builder.

0 Answers  

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

How to create new table with "create table" statements?

0 Answers  

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

---

How to delete a database in ms sql server?

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---