Will a CHECK constraint work for you?





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Manu varghese
[mailto:mssqldba-ezmlmshield-x98917802.[Email address protected]
Sent: Tuesday, January 30, 2007 6:51 AM
To: LazyDBA Discussion
Subject: Constraint

Hi All

I have a table with 5 columns say a,b,c,d,e. Where column 'e' is of
datatype datetime and all the rest are of nvarchar. I need a constraint
that any one the four columns (a,b,c,d) should be editable if the date
in the column 'e' should be garater than current date


Please help...


Regards
Manu.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page