All I need is a rhythm divine
Lost in the music, your heart will be mine
All I need is to look in your eyes
Viva la musica, say you'll be mine
Foreign Key vs. Trigger Referential Integrity in SQL Server

a lot of database models where the original developer had enforced basic referential integrity (RI) using triggers rather than declaratively via foreign keys. In versions prior to SQL Server 2000,…