Answer Posted / anand

3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005

DDL and LOGON are used to administrator related tasks

Can you explain what is sql server english query?

948

---

What are the advantages to use stored procedures?

1032

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1166

---

What happens when converting big values to integers?

956

---

What are the advantages of using third-party tools?

917

---

What are .mdf files?

886

---

How do I create a stored procedure in dbml?

927

---

What number sorts of privileges are accessible in sql?

979

---

Can sub report data source be different from that of the parent report?

135

---

What will be query used to get the list of triggers in a database?

954

---

What is data block and how to define data block size?

977

---

When multiple after triggers are attached to sql table, how to control the order of execution?

977

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

997

---

What is the exact numeric data type in sql?

960

---

How to create stored procedures with parameters in ms sql server?

991

---