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
What the different components in replication and what is their use?
What is the difference between upgrade and migration in sql server?
What is spid in sql server profiler?
How to sort query output in descending order in ms sql server?
How do I find the port number for sql server?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is 1nf 2nf?
How to add additional conditions in SQL?
where can you add custom error messages to sql server? : Sql server administration
Do you know how to implement service broker?
Do you know the different ddl commands in sql?
What options are available to audit login activity? : sql server security
Suggest a method of joining two tables.
What are the types of subscriptions in SQL Server replication?
How to make a remote connection in a database?
