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....

How to use group functions in the select clause in ms sql server?

0 Answers  

---

How many databases instances are there in sql server 2000?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

How do you create a clustered index?

0 Answers  

---

Explain primary key and foreign key constraints?

0 Answers  

---

What is sql server query analyzer?

0 Answers  

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

Do you know query execution plan?

0 Answers  

---