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

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

What are Row versions of DataRow?

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,

---

Does group by sort data?

0 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

What is Self Join?

4 Answers  

---

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---