Dot Guru

Definitions: It is special kind of Stored Procedure which is executed whenever specific event is occurred in/on a table or database 2 types in Sql server 2000: 1. DML Trigger Instead of triggers After triggers 3 types in Sql server 2005: •  DML Triggers Instead of triggers After triggers •  DDL Triggers •  CLR Triggers 2 types in Oracle: Row Level Triggers Statement Triggers

Delete duplicate rows - sql server 2005 http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/