Answer Posted / digvijay kumar singh

Magic table is Temporary type table. it is created when
trigger perform the insert,delete and update action. trigger
have two type magic table:-
1:- inserted table.
2:- deleted table.

when trigger perform the insert and update action on table
then trigger used the Inserted magic table and deleted magic
table used at deletion time.




i hope you will understand..................

Can You Use Data Mining Models In Ssrs?

138

---

how many clustered indexes can be created on a table? : Sql server database administration

1064

---

Explain comment on transactions?

934

---

What is sql profiler. What are the default templates with it? : sql server database administration

949

---

List out what other servers you can use with ssrs?

130

---

What is difference between cte and view?

854

---

How can you insert null values in a column while inserting the data?

1210

---

Explain the concepts and capabilities of sql server?

922

---

How to rebuild indexes with alter index ... Rebuild?

1030

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1011

---

What is the purpose of a table?

905

---

What is a livelock?

911

---

What is openxml in sql server?

1104

---

What is plan freezing?

907

---

what is package and it uses and how can u call a package

1949

---