Answer Posted / subbu

suppose if we write a trigger on the table on insert or
delete or update

on insertion of record into that table,
inserted table will create automatically by database,

on deletion of record from that table,
deleted table will create automatically by database,

This two tables inserted and deleted are called magic
tables.

What is trace flag in sql server?

1080

---

What is user-defined multi-statement table-valued function?

1120

---

How do I save a stored procedure in sql server?

1052

---

What is a primary index?

977

---

What is the difference between stored procedure and functions?

1199

---

What is dbcc? Give few examples.

1083

---

How to identify current user in ssrs report?

408

---

How to get a list all databases on the sql server?

1160

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1126

---

What is report snapshot?

163

---

What are the types of sql server?

1099

---

What is an index. What are the types?

1162

---

Explain how to use linked server?

1032

---

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

1171

---

What are the new features of sql server 2012 reporting service?

141

---