Interested to Buy Any Domain ? << Click Here >> for more details...
What is Trigger?
- 3 Answers
- 10901 Views
- Misys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti-khammam
Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pawan378
above answers are correct.
let me add some thing.
Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.
| Is This Answer Correct ? | 5 Yes | 0 No |
Questions regarding Raiseerror?
what is the difference between table and view
Explain the properties of sub-query in sql server?
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.
How to use order by with union operators in ms sql server?
Why is replication required on the sql server?
Do you have any idea about the tcl commands?
What is self contained multi valued query?
What happens to a trigger with multiple affected rows?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain temporary table vs table variable by using cursor alternative?
What is difference between join and natural join?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
