what is trigger . hw will it use them

Answer Posted / m.ramarathna

Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.


when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a code to select distinct records without using the DISTINCT keyword.

851


What is master database? : SQL Server Architecture

712


What is the difference RDBMS and Graph Database?

807


What is difference statement and preparedstatement?

727


What is cube dimension? : sql server analysis services, ssas

716


Is sql server is free?

706


What is best institute to Learn DotNET And SQL in chennai?

1902


How to select some specific columns from a table in a query in ms sql server?

727


What is ems sql management studio? : sql server management studio

763


What are the benefits of normalization?

789


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1291


What is user defined datatypes and when you should go for them?

772


What are the different authentication modes in sql server?

811


What is linked report?

104


What are data driven subscriptions?

95