What are the two virtual tables SQL Server maintains for
triggers?
- 3 Answers
- 7486 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
can SSRS reports Cache results?
What is a trace frag? Where do we use it?
What is the syntax to execute the sys.dm_db_missing_index_details?
Explain primary key?
What is the difference between count and distinct count?
Explain how does the report manager work in ssrs?
What are sub reports?
Is it possible to replicate data from sql server to oracle? : sql server replication
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
List out a number of the wants to setup a SQL Server failover cluster?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is xdr?
Where is my database stored on the hard disk in ms sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what are the disadvantages of cursors? : Sql server database administration
