Re: [NF] SQL Server 2008 column constraint question

2012-07-13 Thread Stephen Russell
On Thu, Jul 12, 2012 at 10:13 PM, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've seen how to create a rule for data in a column using direct values

Re: [NF] SQL Server 2008 column constraint question

2012-07-13 Thread MB Software Solutions, LLC
On 7/13/2012 12:18 AM, Dan Covill wrote: On 07/12/12 20:13, MB Software Solutions General Account wrote: I've seen how to create a rule for data in a column using direct values

[NF] SQL Server 2008 column constraint question

2012-07-12 Thread MB Software Solutions General Account
I've seen how to create a rule for data in a column using direct values (http://www.databasejournal.com/features/mssql/article.php/3811831/Using-Check-Constraints-to-Validate-Data-in-SQL-Server.htm). But I want to basically say Only allow values in this FK field that exist as PKs in that other

Re: [NF] SQL Server 2008 column constraint question

2012-07-12 Thread Dan Covill
On 07/12/12 20:13, MB Software Solutions General Account wrote: I've seen how to create a rule for data in a column using direct values (http://www.databasejournal.com/features/mssql/article.php/3811831/Using-Check-Constraints-to-Validate-Data-in-SQL-Server.htm). But I want to basically say