Hi Manu,

Yes, go for trigger.....

Regards,
Chetan


-----Original Message-----
From: Piyush Dhangar
[mailto:mssqldba-ezmlmshield-x15154640.[Email address protected]
Sent: 30 January 2007 12:22
To: LazyDBA Discussion
Subject: RE: Constraint

Hi Manu

Can't understand columns to be editable, are you mixing application and
database.


-----Original Message-----
From: Manu varghese
[mailto:mssqldba-ezmlmshield-x98917802.[Email address protected]
Sent: Tuesday, January 30, 2007 5:21 PM
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


---------------------------------------------------------------------
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