Answer Posted / puneet sharma

INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.

What is application role in sql server database security? : sql server security

1061

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1006

---

what method you can use to reduce the overhead of Reporting Services data sources?

255

---

What are dml (data manipulation language) statements in ms sql server?

986

---

Explain left outer join and right outer join?

1044

---

Can we use trigger new in before insert?

925

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1074

---

List out some of the requirements to set up a sql server failover cluster?

1034

---

What action plan is preferred if sql server is not responding?

1105

---

What is relationship? What number of sorts of relationship are there?

1142

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1961

---

What is transact-sql language?

1099

---

What is policy based management (pbm)? : sql server database administration

991

---

Is it important for a database administrator to understand the operating system and file access?

1002

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---