Answer Posted / sri

The 2 virtual tables are the OLD and the NEW

OLD is invalid in the case of INSERT and NEW is invalid in
the case of DELETE statements

Inside the trigger we can use the OLD and NEW as follows

:OLD.columnname
:NEW.columnname

How to connect a database with sql express.?

1046

---

what is bit datatype? : Sql server database administration

897

---

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

1105

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1167

---

How to set a database state to offline in ms sql server?

1021

---

What is the recovery model? List the types of recovery model available in sql server?

884

---

Explain the various types of concurrency problem?

1164

---

Explain trigger classes i.e. Instead of and after trigger?

861

---

Explain multiserver query

1006

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1123

---

Do you know sql server 2008 introduces automatic auditing?

958

---

Find first and last day of current month in sql server

1008

---

Explain about local stored procedure?

942

---

How do I find query history in sql server?

925

---

Give me a SQL Query to find out the second largest company?

1150

---