Answer Posted / imran badrampalli

There are 2 Magic Tables in SQL server Inserted and Deleted.
These are mantained by SQL server for Internal processing
whenever an update, insert of delete occur on a table.
However, we can refere these tables in a Trigger.
Whenever an update table statement is fired SQL server
mantains the original row before updation in a deleted
table and New (updated )row in a Inserted Table.

Same is the case when an insert is fired Only Inserted
table is populated with inserted Row.
and when Delete table statement is fired Deleted table is
populated with the deleted row.

Is it possible to update the views? If yes, how, if not, why?

1085

---

What are the essential components of sql server service broker?

1065

---

Can you explain what are various ways to enhance the ssrs report?

1066

---

What is difference between sql and sql server?

1081

---

What happens if the update subquery returns multiple rows in ms sql server?

1171

---

How can we determine what objects a user-defined function depends upon?

1074

---

Explain in brief how sql server enhances scalability of the database system?

1026

---

What is sharding?

116

---

What is resource db in sql server?

1058

---

Difference between report and query parameter. Why do we need different type of parameter?

1011

---

What is the difference between functions and stored procedures?

1222

---

What do you mean by data manipulation language?

1063

---

What is data source object?

1064

---

Does index speed up select statements?

1074

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

---