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

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

What is a recursive stored procedure in sql server?

0 Answers  

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---

What are the five major components of a dbms?

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---