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 is Check point? Explain in Brief what it will do?
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
What is a trigger what are the advantages of trigger?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Define full outer join in sql server joins?
what is the diffrence between Snap Shot and Transaction Replication
Why de-normalization required?
How can you find out which stored procedures are recompiling?
Describe triggers features and limitations?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many