Answer / laxman

OLD and NEW tables for oracle.

For sql server inserted & deleted.

Answer / sanjeev kumar

Two virtual tables are:
1) Inserted
2) Deleted

these two tables are also called magic table.
it has no any physical existence. it is used to keep trac of
the previous data when DML operation used.
it's used in a trigger.

Example:
Create trigger testtri on test3
for update
as
begin
declare @previousname varchar(50) -- local variable
select @previousname = del.name from deleted del
insert into test(name)values(@previousname)
end

Answer / 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

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

Describe how to use linked server?

0 Answers  

---

What is meant by indexing files?

0 Answers  

---

How to convert a numeric expression from one data type to another?

0 Answers  

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---