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 |
What does it mean to invest in the index?
wat is the main diff between sql server 2000and sql server 2005
Diff. b/w Full Outer Join And Cross Join?
What are the types of containers in ssis?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
Is sql server difficult to learn?
Please explain what is “asynchronous” communication in sql server service broker?
What is the purpose of update statistics and scope_identity() function?
What is the server name for sql management studio?
What do you understand by the denormalisation?
How do you persist objects, permissions in tempdb
Explain “not null constraint” in sql server?
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)