Answer Posted / rami reddy.k
Triggers are the system generated events.
for example,
u have a table emp,in tat u can create a trigger which will
be activated if anyone performs any action such as insert,
update, delete on tat table.In tat trigger u can write code
which copies the updated info into another table.
A trigger is a stored procedure that goes into effect when
you insert, delete, or update data in a table. You can use
triggers to perform a number of automatic actions, such as
cascading changes through related tables, enforcing column
restrictions, comparing the results of data modifications,
and maintaining the referential integrity of data across a
database.
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
How to remove duplicate rows from table except one?
What are the differences between sql server and mysql.
How can you ensure that the database and sql server based application perform well?
What is extended stored procedures?
What is a data source or ds? : sql server analysis services, ssas
How connect excel to sql server?
what is a check constraint?
How do I run a trace in sql server?
What are sp_configure commands and set commands?
What is the maximum size of a row in sql server?
What is difference between after and before?
What are sql dirty pages?
What are the difference between “where” and “having” clause in sql server?
What are logical/boolean operations in ms sql server?
What command do we use to rename a db, a table and a column?