what is meant by trigger?

Answer Posted / mrniceksa

A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. Triggers can query other tables and can include
complex SQL statements. They are primarily useful for
enforcing complex business rules or requirements. For
example, you could control whether to allow an order to be
inserted based on a customer's current account status.

Is This Answer Correct ?    46 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is log files in qtp what is use

1587


what is the difference between read the data from table and infotype

2051


Is anyone has done the ASP.NET MVC4 workshop course(2 days) from Peers Technologies. Let me know. I need to talk before joining ASP.NET MVC4 training at peers, Hyderabad.

1550


What's the difference b/w Table & Templete in Smartform?

1641


Write a program to find whether a given number is prime or not.

604






Why did you ever become involved in QA/testing?

1603


what are the topics choosen for jam round for interviews

1155


what is the difference between uservariables and systemvariables (in Environmental variables)???

1935


Given an array of size n. It contains numbers in the range 1 to n. Find the numbers which aren?t present.

621


how can i create report in abap to insert data in table pa0002 using insert command

1704


How to call dll API sub routine in VB Form.

1905


How do i find out the number of parameters passed into function?

2209


How to call a C++ function which is compiled with C++ compiler in C code?

789


what is web configuration file

1538


how to convert the data from HTML file to SAS dataset?

2188