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 do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What happens when converting big values to numeric data types?

0 Answers  

---

What is the sql server agent?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

What is merge statement?

0 Answers  

---

Explain in brief about Microsoft SQL server?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---

How to change server name in sql server?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---