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,920 reads
Dan Ryan
Blogs
How to get data in a DataFrame via .NET for Apache Spark
By Ed Elliott
When I first started working with Apache Spark, one of the things I struggled...
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Forums
Linked Server Insert error
Hello i have linked server one server in cloud one is local from local...
Default Credentials
Comments posted to this topic are about the item Default Credentials
Re-OPENing a Cursor
Comments posted to this topic are about the item Re-OPENing a Cursor
Ask SSC