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.

Explain can SSRS reports Cache results?

158

---

Explain what is the function of sql server agent windows service?

994

---

What is the difference between clustered and a non-clustered index?

1028

---

Which tcp/ip port does sql server run on? How can it be changed?

1042

---

What are the two modes of authentication in sql server?

1069

---

Explain SSRS Architecture?

195

---

What are the difference between primary key and unique key? : sql server database administration

942

---

What are the extra roles available in msdb? : sql server security

1134

---

can an automatic recovery be initiated by a user? : Sql server administration

954

---

What is difference between foreign key and unique key?

1011

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

Is t sql the same as sql server?

975

---

Can you move the resources after pausing the node? : sql server database administration

1104

---

What is the temp table?

923

---

Define inner join? Explain with an example?

997

---