Answer Posted / ajay kumar

Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.

What are the restrictions applicable while creating views? : SQL Server Architecture

978

---

What is an expression in ms sql server?

1009

---

Explain in brief about Microsoft SQL server?

1010

---

How to check status of stored procedure in sql server?

911

---

What is index fragmentation in ms sql server?

1019

---

How do I view a stored procedure in sql server?

943

---

What are the advantages of sql azure?

138

---

Differentiate between mongodb vs. Sql server?

1029

---

How to enter date and time literals in ms sql server?

951

---

Explain the flow of creating a cube? : sql server analysis services, ssas

1001

---

Explain the steps to create and execute a user-defined function in the sql server?

917

---

What is a domain constraint give an example?

1002

---

How to connect of datebase with sql express.?

1049

---

What is the difference RDBMS and Graph Database?

1003

---

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

981

---