Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two virtual tables SQL Server maintains for
triggers?
- 3 Answers
- 8466 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
What according to you is the difference between mysql and sql server performance?
Does a sql server 2005 select statement require a from?
What is the difference between migration and upgradation in sql server?
Explain what is use of dbcc commands?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How can I check that whether automatic statistic update is enabled or not?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Does any body please help me what question's have asked for SSRS in the interview?
Explain something about security and SQL Azure?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What are the advantages of policy management?
How do use Having,Group by,Group function in SQL?
what are constraints? : Sql server database administration
How to disable a login name in ms sql server?
How to use copy and concatenate commands in SQL?
