THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Data Integrity » Database Progra... » Transact SQL   (RSS)
Sorry, but there are no more tags available to filter with.
  • Storing intervals of time with no overlaps.

    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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on March 8, 2009
Privacy Statement