What are the two virtual tables SQL Server maintains for
triggers?
Answer Posted / sri
The 2 virtual tables are the OLD and the NEW
OLD is invalid in the case of INSERT and NEW is invalid in
the case of DELETE statements
Inside the trigger we can use the OLD and NEW as follows
:OLD.columnname
:NEW.columnname
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is normalization 1nf 2nf 3nf?
What is the function of sql server agent windows service?
When you use @@error and try-catch?
Can select statements be used on views in ms sql server?
Explain what is the purpose of sql profiler in sql server?
How to create a view on an existing table in ms sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are the different type of replication in sql server?
What is the purpose of indexing?
What are the disadvantages of merge replication?
What is a not null constraint?
How to defragment table indexes?
What is dbcc?