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 meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Do you know what is sql injection?

0 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

Tell me what is log shipping?

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

Wht is Stuff in sql ser

2 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

Mention the different types of triggers?

0 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

What are the types of indexes?

0 Answers  

---