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

How can sql injection be stopped? : sql server security

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

What is unpivot?

0 Answers  

---

What is a job?

3 Answers  

---

What is difference between index and primary key?

0 Answers  

---

What is the new security features added in sql server 2014? : sql server security

0 Answers  

---

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

What are sql servers used for?

0 Answers  

---