Answer Posted / arvind kumar

Magic tables are Inserted And Deleted which fires when we
use triggers and they are also work like temporary tables to
hold the data.

What is the purpose of a table?

959

---

How adventureworkslt tables are related?

930

---

Describe how to use linked server?

1020

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1143

---

Can you explain what is sql server english query?

996

---

What are the types of lock supported by ?

1046

---

What is scrollable cursor?

1043

---

Differentiate between sql temp table vs table variable?

885

---

What is difference between getdate and sysdatetime in sql server 2008?

1048

---

how to determine the service pack currently installed on sql server? : Sql server database administration

972

---

How to list all dsn entries on your local machine using odbc_data_source()?

1039

---

Explain having clause and where clause?

1056

---

How can we improve performance by using SQL Server profiler?

1056

---

How extra digits are handled with numeric data type literals?

968

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1011

---