Interested to Buy Any Domain ? << Click Here >> for more details...
What is a trigger?
- 7 Answers
- 9069 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sathish kumar.t
Trigger is the collection of T-SQL statements, which is
activated based on certain actions. Trigger is fired, when
any of one DML statements will occur..
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raji
Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures.
The difference is that it can be activated when data is
added or edited or deleted from a table in a database.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / jerry joseph
Triggers are a special type of Stored procedure which
execute automatically when a triggering action like INSERT,
UPDATE or DELETE occurs.
INSTEAD OF trigger
- executes automatically in place of triggering actions like
INSERT, UPDATE or DELETE
- executes before PK, FK constrains are checked
AFTER trigger
- executes automatically after the statement that triggered
it completes
- executes after constrains are checked
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jerry joseph
Trigger gets executed when an INSERT UPDATE or DELETE occurs
2 types of triggers are INSTEAD OF triggers and AFTER triggers
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vimal
Trigger is a special type of store procedure.when we are going
to insert,update,delete table automatically trigger is invoked
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / subodh devarde
Triggers are special type of stored procedure which execute automatically whenever any changes are occured in table in database after using insert update ,delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / channu mamane
triggers are special type of stored procedure which are
automatically invoked at the time of modifyibg tables
| Is This Answer Correct ? | 0 Yes | 1 No |
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to create an multi-statement table-valued function?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain the types of indexes.
Which command is used for user defined error messages?
What are the types of backup and tell me the difference between full and differential backup?
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
How to use subqueries with the in operators in ms sql server?
What are page splits? : SQL Server Architecture
Can we create nonclustered index in a table without creating a clustered index
What is an index in sql?
which one will take 1st priority in case of insert statement and select statement???
-
Oracle (3259) - 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)
