Explain 3 basic parts of a trigger.
Answer / Shyam Sunder
The three basic parts of a trigger are: (1) Event: The event that triggers the execution of the trigger, such as INSERT, UPDATE, or DELETE. (2) Condition: An optional condition that must be met for the trigger to execute. (3) Body: The code executed when the trigger is fired.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are rollup and cube in t-sql? : Transact sql
What will be the output for the below Query Select 'High' from dual where null = null;
Why do we need a foreign key?
Can we call a function containing dml statements in a select query?
How do you explain an index number?
which tcp/ip port does sql server run on? : Sql dba
How to run sql statements through the web interface?
what is the output of this query selet * from employee where 1=2 ??
Why use subqueries instead of joins?
Is subquery faster than join?
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
When sql appeared?
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)