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

How to add a new dsn with the odbc driver for sql server?

644


How to get a list of all tables with "sys.tables" view in ms sql server?

670


What are binary string data types in ms sql server?

735


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

760


Define full outer join?

606






Is a primary key unique?

616


In which files does sql server actually store data?

558


What is history table in sql server?

579


what is hash nonclustered index

624


When do you think a developer should use sql server-based cursors?

610


How do clustered indexes store data?

704


What is difference between cte and view?

605


What is a result set object returned by mssql_query()?

659


What are different types of collation sensitivity?

622


What are data resources?

579