Interested to Buy Any Domain ? << Click Here >> for more details...
What is Trigger?
- 3 Answers
- 10763 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 |
What will be the maximum number of index per table?
What is an Index?
Explain go command in sql server?
Explain the rules for designing files and file groups in sql server?
Which are ddl commands?
What is checkpoint in sql server?
What is the difference between truncate and delete statement?
6 Answers CarrizalSoft Technologies, CTS,
Explain about SQLOS?
Why do you need a sql server?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
-
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)
