Triggers to Enforce Data Consistency in SQL Server

Question

Hi friends

I want to know how to use triggers to enforce data consistency in SQL Server. 

Thank you.