Enforce business rules with indexed views and a two-row table
Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.
2012-08-20
7,888 reads
Dan Ryan
Blogs
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
update table b if b.time falls between any of table a rows start/stop
I'm trying to find a way to rewrite this dusty old cursor set based,...
Check if number exists in a column
Hello, I am pulling some address data from a legacy system and it has...
Ask SSC