what is trigger . hw will it use them

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is model database in sql server?

779


What is attribute hierarchy? : sql server analysis services, ssas

713


How to find the login name linked to a given user name?

675


What is the full form of ddl?

671


What is difference between materialized view and view?

692






Do you know what is a with(nolock)?

794


What is transaction server distributed transaction?

726


How is SQL Azure different than SQL server?

116


What is system stored procedures?

760


How do you debug a procedure in sql server?

638


How to download and install the scaled-down database adventureworkslt?

783


Difference between Sql server reporting services and Crystal reports?

137


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

844


why would you use sql agent? : Sql server database administration

772


What is plan freezing?

724