What is Trigger?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pawan378
above answers are correct.
let me add some thing.
Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.
Is This Answer Correct ? | 5 Yes | 0 No |
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
What is the difference between a local and a global temporary table?
What are differences in between sql server 2012 and sql server 2016?
Does sql server 2016 have ssms?
What is updatable resultset?
How get current date in SQL server 2000
What are the lambda triggers?
How to perform key word search in tables?
Explain database normalization?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
What is Extended user-defined?