what is meant by trigger?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bgg
trigger is something which is executed when some specified
event occurs.
two main specifications are-
1.when the trigger should be executed(event)
2.what action must be taken when this event occurs
| Is This Answer Correct ? | 15 Yes | 5 No |
Answer / sagaya maria virgin
a trigger is a statement that system execute automatically
as a side effect of a modification of database.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / dinesh kumar
Trigger can be defined as a action that is performed on
data when event occur. Here action can modify data from
database, insert data into database etc.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / srikanth
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.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / a.palanisamy
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. in future use u can get old data from specified table
| Is This Answer Correct ? | 0 Yes | 1 No |
class A{ void me(){s.o.p("");} class B extends A{ void me() {s.o.p(" ");} class M{ A a=new B(); B b=new A(); a.me(); b.mne();} what is the output of this, how?
2 Answers Cosmos, HyTech Pro, WinSoft,
What are scrubbing procedures in SAS
hai i am mca 2009 fresher.please tell me which certification helps me to get an IT job faster which institute is good in hyderabad.please mail me to prasanna.1856@rediff.com
Iam using Microsoft Visual Studio to create a system for mobile store I want to know how to calculate mobile price that the customer buy and how to reduce quantity from the data base that we have for mobile .And also how to calculate revnue for each mobile and revnue for the total mobile
what is the difference between set and append?
Which design patterns have you used?
what is jackson structured develepment?? and how is it different from OMT??
what are the things i had to say in personal introduction in hr round mail me to prasanna.1867@rediff.com
what are other resources are needed for this mantis?
SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge
is it possible to learn sap from book without any tutorial. if yes please mention the beginner,s book of sap and also make your valuable advice for self study of sap .
what is inprocess and outprocess in vb