What is a trigger?

Answer Posted / subodh devarde

Triggers are special type of stored procedure which execute automatically whenever any changes are occured in table in database after using insert update ,delete command.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 10 characteristics of data quality?

679


Is it possible to create trigger on views?

710


Explain what is dbcc?

777


How to select all columns of all rows from a table with a select statement in ms sql server?

747


Explain ranking functions?

778






What are various ways to enhance the ssrs report?

716


How will you find out if there are expensive SQL statements running or not?

762


Explain for xml explicit mode?

734


what are the critical issues you have resloved in your company

1724


How to count duplicated values in a column in ms sql server?

700


What is the use of @@spid?

737


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

738


Explain what is “asynchronous” communication in sql server service broker?

663


What is the contrast amongst drop and truncate?

750


Explain the difference between functions and stored procedures in sql server?

672