Answer Posted / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

What do you mean by tablesample?

634

---

How to list all field names in the result set using mssql_field_name()?

522

---

How can I create a report based on a query? : sql server management studio

556

---

What is a cache in ssrs?

110

---

What is a group function explain with an example?

519

---

---

What are the types of normalization?

547

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

675

---

Does partitioning ssd reduce performance?

486

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1781

---

What are drillthrough reports?

102

---

Is a primary key unique?

533

---

Explain about protocol layer present in SQL server?

609

---

What is report subscription?

91

---

Ms sql server index?

534

---

What is key set driven?

537

---