Answer Posted / shilpa

triggers are fired automatically when any event ocours like
update ,delete ,insert on a table
whereas sp is set of sql statements its not related to
single table but its can have many sql satements that can
be used in many tables to update, delete and insert .

what are the different types of replication you can set up in sql server? : Sql server database administration

968

---

What is dml command?

886

---

What sql server means?

908

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1945

---

Why use sub query in sql server and list out types of sub queries?

935

---

What command do we use to rename a db, a table and a column?

870

---

Write a sql query to display the current date?

1027

---

What is isnull() operator?

971

---

Is the order of columns in the set clause important in ms sql server?

925

---

What is truncate table?

888

---

Can we use trigger new in before insert?

864

---

What is the most common type of join?

909

---

Explain transaction isolation levels in sql server?

1034

---

What are window functions in sql server?

934

---

Why should you use or avoid select * statements?

964

---