I have a table in SQL Server named CustInfo that is as follows:
table CustInfo (
I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For example:
2008-01-01,2008-10-27,11,'13 Lexington st'
...meaning that I want to prohibit inserting any records between those dates for customer 11. However, I do not want to use stored procedures. Is there a way to do this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!