wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
Answers were Sorted based on User's Feedback
Answer / vimal p.s
A trigger is a SQL procedure that initiates an action when
an event (INSERT, DELETE or UPDATE) occurs. Triggers are
stored in and managed by the DBMS.Triggers are used to
maintain the referential integrity of data by changing the
data in a systematic fashion. A trigger cannot be called or
executed; the DBMS automatically fires the trigger as a
result of a data modification to the associated table.
Triggers can be viewed as similar to stored procedures in
that both consist of procedural logic that is stored at the
database level. Stored procedures, however, are not event-
drive and are not attached to a specific table as triggers
are. Stored procedures are explicitly executed by invoking
a CALL to the procedure while triggers are implicitly
executed. In addition, triggers can also execute stored
procedures.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / radhakrishnan vaithilingam
Def Trigger : bascially trigger means "activate or generate
or fire".if we touch any column automaticcaly some event
accure in database.
use :
1) if update or insert or delete more than one table we can
use this concept.
2) trigger reduce coding error and reduce wrong action
3) we can trace the system login or logoff inforamtion.
this is system trigger.
example :
1) bank account
if we retrive the money from ATM. the money automatically
reduced from your account immediate.
2) fire alarm
Is This Answer Correct ? | 3 Yes | 0 No |
What is field in algebra?
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the difference between clustered and non-clustered indexes in ms sql server?
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
What is a heap?
What the difference between UNION and UNIONALL?
How to generate create table script on an existing table in ms sql server?
How many types of system privileges are there, Can we add or delete privileges?
Explain about the command-line tool SQLCMD?
1 01 101 01010
List out a number of the wants to setup a SQL Server failover cluster?
How to define output parameters in stored procedures?