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
8,062 reads
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
8,062 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Microsoft is warning of a "BREAKING CHANGE" and indeed this little update took my...
Hi everyone, In below code I am creating a table and inserting some english...