Which virtual table does a trigger use?
Answers were Sorted based on User's Feedback
Answer / bharathi
Answer is deleted and inserted
INSERT Trigger populates inserted table
DELETE Trigger populates deleted table
UPDATE Trigger poulates both inserted and deleted tables
| Is This Answer Correct ? | 11 Yes | 0 No |
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
How to bind a view to the schema of the underlying tables?
Explain cross join or cartesian product in sql?
What is check constraint in sql server?
What is the difference between a unique key and primary key?
What is the optimization being performed in oracle and SQL Server?
Where the sql logs gets stored?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
Alternative way to DetDate() function?
How would you choose between a clustered and a non-clustered index?
What are filegroups in sql server?
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)