Interested to Buy Any Domain ? << Click Here >> for more details...
wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
- 2 Answers
- 6163 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to execute a sql statement using mssql_query()?
tell me the disaster recovery plan
What is difference between count (*) and count column?
Difference between DELETE and TRUNCATE?
Explain active/passive and active/active cluster configurations?
What is report subscription?
can an automatic recovery be initiated by a user? : Sql server administration
What is the use of stored procedure?
What is clustered primary key?
What is the purpose of indexing?
How can you fetch alternate records from a table?
What is self contained scalar sub query?
What do you understand by triggers and mention the different types of it?
What is data compression? : sql server database administration
How to select some specific rows from a table in ms sql server?
