var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Public Holidays
I need to write a constraint for the following scenario.
When inserting a new record for Table 'PracticalSession', I need to check that PracticalSession.StartDate doesn't fall on a Public Holiday.
What would be a simple way to implement this ?
I was thinking of creating a INSERT/UPDATE TRIGGER
that will check against a predefined table called 'Holidays'.
What do you guys think ?
If you need this constraint then I would instead have a table of working days and implement a standard, declarative foreign key to that. Much simpler and less code than using triggers.
ur codings are working excelent.