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

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

How the data stores in a page?

1 Answers  

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

How do you rename a table in sql server?

0 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

Which are the olap features?

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

Is truncate a dml command?

0 Answers  

---

Questions on identity?

2 Answers   Infosys,

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---