Answer Posted / kirti kumar agarwal

The INSERTED and DELETED tables, popularly known as MAGIC
TABLES, and update () and columns_updated() functions can
be used to determine the changes being caused by the DML
statements.
Note that the Magic Table does not contain the information
about the columns of the data-type text, ntext, or image.
Attempting to access these columns will cause an error.

How can we use ConnectorJ JDBC Driver with MS SQL?

948

---

What authentication modes does sql server support?

1017

---

How to find the service pack installed? : sql server database administration

970

---

When you use @@error and try-catch?

980

---

How to create a simple table to test triggers in ms sql server?

911

---

What language is sql server written in?

983

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

---

Explain partitioned view?

1019

---

how you can deploy an ssrs report?

172

---

What are the source of constraints?

857

---

Explain unique key in sql server?

952

---

Can sql servers link to other servers?

1020

---

Can we use pragma autonomous_transaction in trigger?

908

---

How to encrypt Strored Procedure in SQL SERVER?

1096

---

Explain the difference between functions and stored procedures in sql server?

918

---