Viewing 4 posts - 1 through 4 (of 4 total)
1) If you insist on "begin" and "end" as separate columns, what about a function based table constraint, where the function checks for overlapping ranges?
Because function based table constraints are...
February 19, 2013 at 8:50 am
Steve Jones - SSC Editor (11/12/2008)
February 19, 2013 at 3:00 am
There is much more to constraint handling than referential integrity constraints and at present triggers are the most viable way to implement these kinds of constraints.
For example for hotel...
February 19, 2013 at 12:32 am
It depends entirely on the business requirements.
As an example, I tried using change data capture to represent historical changes to tables.
However one of the business requirements was that if...
March 13, 2012 at 5:01 am
Viewing 4 posts - 1 through 4 (of 4 total)