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
Does a full backup include transaction log?
How to filter out duplications in the returning rows in ms sql server?
What are the different types of columns types constraints in the sql server?
What is database black box testing?
What is the process of indexing?
What is query cost in sql server?
What is mapping schema?
What are filegroups in sql server?
Which rendering formats are affected by the pagesize properties?
Can you force a query to use a specific index?
How you can minimize the deadlock situation?
What is raid, and how it can influence database performance?
What are the Advantages of using CTE in sql server?
Explain linked server in sql?
Tell me about the approaches which you used to counter the DI problems.