The Smart Guide to Building World-Class Applications
Thank you for recommending "SQL Server Pro is the leading independent community for DBAs and developers who build and manage Microsoft SQL Server database applications. ". Your recommendation has been successfully processed.
Friend 1
DROP VIEW ITEM_IN_TRAY_OR_BOX_V DROP TABLE NUMS DROP TABLE ITEM_IN_TRAY DROP TABLE ITEM_IN_BOX DROP TABLE ITEM
ARTICLE TOOLS
Very cool. I wrote about this exact subject a year ago.http://dbwhisperer.blogspot.com/2008/11/adding-check-constraint-to-view.htmlBut the implementations were different, in my case, I didn't make use of a nums table.