Answer Posted / anand k

the magic tables are deleted and inserted.
while we are inserting or deleting a rows into a object the
magic tables were created and after the commit transaction
the tables are removed.so it is called magic tables

How do you delete duplicate records in sql server?

1058

---

What is coalesce and check constraint in sql server?

1122

---

Can you explain what is indexed view? How to create it?

908

---

Why do we use non clustered index?

1083

---

What is isnull() operator?

1040

---

Are semicolons required at the end of sql statements in sql server 2005?

995

---

What is dimension table? : sql server analysis services, ssas

1020

---

What does nvl stand for?

944

---

what is a transaction? : Sql server database administration

994

---

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

1023

---

Tell about MOM Tool(Microsoft Operator Manager)?

1914

---

What are the components of dbms?

954

---

Explain system functions or built-in functions? What are different types of system functions?

980

---

How to drop an existing table?

1007

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1035

---