Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two virtual tables SQL Server maintains for
triggers?
- 3 Answers
- 8500 Views
- I also Faced
- E-Mail Answers
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
Is t sql the same as sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
What is the log shipping?
What is a cursor, index in sql?
Explain four layers of abstraction microsoft architectured?
What is the difference between insensitive and scroll cursor?
What are the steps to insert a table?
What is a file group?
How to create a large table with random data for index testing in ms sql server?
How many replicas are maintained for each sql azure db?
What are different types of views?
What is named calculation? : sql server analysis services, ssas
Where cross join is used?
How to enable tcp/ip protocol on a sql server?
What is difference between clustered index and non clustered index?
