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

Does group by sort data?

0 Answers  

---

How to convert numeric expression data types by assignment operations?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

What is Transaction?

2 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

What is difference between index seek vs. Index scan?

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---