CHECK Constraints vs. TRIGGERS

  • Article

I've been having a conversation with a customer about CHECK constraints and TRIGGERs, and I thought it would be good to survey some of our customers about how people use these features.

I'm curious how many people encode business logic validation in CHECK constraints.  I'm also curious about what you would LIKE to encode in CHECK constraints but can't.  Alternatively, if you prefer the procedural approach, I'd like to hear your thoughts on that as well.

Please send me a mail, and I'll summarize some of the findings: conorc @ microsoft.com

 Thanks,

Conor