Answer Posted / 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

What is function of master database?

114

---

How to perform key word search in tables?

910

---

How to connect sql server management studio express to sql server 2005 express?

966

---

What is the difference between mysql and mysqli?

1083

---

How to provide values to user defined function parameters?

968

---

Differentiate between a local and a global temporary table?

898

---

What do you need to connect php to sql server?

1038

---

Scalability, Availability, Integration with internet, etc.)?

2821

---

Can we use where clause in union?

1001

---

Name the different type of indexes in sql?

907

---

What are page splits? : SQL Server Architecture

935

---

What is difference between sql and sql server?

937

---

What is spatial and temporal data?

931

---

what is hash nonclustered index

907

---

What are the differences between stored procedure and the dynamic sql?

1026

---