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 are the types of subquery?
How to call a function from a stored procedure in SQL Server ?
What is the purpose of optimization?
What are the different subsets of sql?
How to execute multiple stored procedures at one time in sql server?
When you should use a low fill factor?
What is the difference between mysql and mysqli?
What are the filtered indexes?
Which sql server is best?
What is auditing in sql server?
Explain transaction server distributed transaction?
What is bulkcopy in sql?
Explain microsoft sql server functions?
What does null mean?
Does group by sort data?