THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Transact SQL » Data Integrity » Database Programming   (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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement