» Transact SQL
» Database Progra...
» Data Integrity (RSS)
Sorry, but there are no more tags available to filter with.
I will demonstrate how use constraints to make sure that
intervals of time have no overlaps. Also you may ensure that there are no gaps
either, but if you choose to allow gaps, then the query to retrieve them is
very easy. As discussed in my previous posts, you can also use triggers or UDFs
wrapped in CHECK constraints, but only trusted ...