What is Trigger?

Answer Posted / koti-khammam

Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we get count of the number of records in a table?

544


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

599


What is raid and what are different types of raid levels?

592


Define compound operators?

533


What is role playing dimension with two examples? : sql server analysis services, ssas

588






Detail about the hardware which is supported by SQL server?

589


How to insert stored procedure result into temporary table?

581


What are the Advantages of using CTE in sql server?

570


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1489


What is store procedure?

645


Explain indexes disadvantages?

546


Explain magic tables in sql server?

549


What are the different types of upgrades that can be performed in sql server?

689


How to rebuild all indexes on a single table?

585


What is 'Join' and explain its various types.

627