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
- 6209 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
What happens if date-only values are provided as date and time literals?
What guidelines should be followed to help minimize deadlocks?
Can truncate be rolled back?
How connect excel to sql server?
How can you ensure that the database and sql server based application perform well?
A trigger can reference objects outside the current database? State true or false.
How do you delete a data source?
How to assign new column names in a view?
What new changes are being made in SQL Server?
What are the steps you will take to improve the performance of a poor performing query?
Explain few of the new features of sql server 2008 management studio
How do I start sql server?
What is thr feature of change data capture?
What is the difference between Clustered and Non-Clustered Index?
What are security principals used in sql server 2005?
