what is trigger . hw will it use them

Answers were Sorted based on User's Feedback



what is trigger . hw will it use them..

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 .

Is This Answer Correct ?    10 Yes 2 No

what is trigger . hw will it use them..

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are tasks?

3 Answers   Wipro,


What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,


Explain throw statement in sql server 2008?

0 Answers  


How to change the name of a database user?

0 Answers  


What sql server means?

0 Answers  






how insert selected column only ?

3 Answers   Robert Half,


Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  


Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,


I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  


What is meant by datasource?

0 Answers  


Define compound operators?

0 Answers  


Categories