Interested to Buy Any Domain ? << Click Here >> for more details...
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 list all user names in a database?
What are a scheduled jobs or what is a scheduled tasks?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are the different types of data sources in ssrs?
How to create a new login name in ms sql server?
Can we do dml on views?
What do you understand by a stored procedure?
What is command parameter in ssrs?
What is the syntax for encrypting a column in SQL Server?
What is difference between equi join and natural join?
What is normalization process?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
List few advantages of stored procedure.
Explain data warehousing in sql server?
Write an SQL query to obtain the 2nd highest salary.
