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

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1084

---

What is the index requirement in SQL Azure?

98

---

What is sql server used for?

1036

---

What are the types of ssrs?

145

---

What is difference between drop truncate and delete?

1078

---

How can we check the sql server version?

1053

---

What is query parameter in ssrs?

160

---

What happens if null values are involved in datetime operations?

965

---

What is a fan-out query in SQL Azure?

121

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2068

---

How to copy the tables, schema and views from one sql server to another?

1038

---

Can you use order by when defining a view?

966

---

Explain about local stored procedure?

962

---

How to create function with parameter in sql server?

1095

---

Define cross join in sql server joins?

1014

---