What is a trigger?

Answer Posted / sathish kumar.t

Trigger is the collection of T-SQL statements, which is
activated based on certain actions. Trigger is fired, when
any of one DML statements will occur..

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is port 1433 secure?

736


What is the difference between a stored procedure and a user defined function?

746


What is the significance of null value and why should we avoid permitting null values?

725


Describe the functionalities that views support.

845


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

778






How do you use a subquery to find records that exist in one table and do not exist in another?

741


What is the definition for sql server 2000?

788


How to create a testing table with test data in ms sql server?

738


What is ms sql server reporting services?

724


Explain about thread and memory management process of SQL?

721


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1760


What is report server project?

122


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

689


What are trace files?

705


What is rolap and its advantage? : sql server analysis services, ssas

937