Mega Code Archive
CHECK Constraints for current date
<![CDATA[
3>
4>
5> CREATE TABLE Customers
6> (
7> CustomerNo int IDENTITY NOT NULL
8> PRIMARY KEY,
9> CustomerName varchar(30) NOT NULL,
10> Address1 varchar(30) NOT NULL,
11> Address2 varchar(30) NOT NULL,
12> City varchar(20) NOT NULL,
13> State char(2) NOT NULL,
14> Zip varchar(10) NOT NULL,
15> Contact varchar(25) NOT NULL,
16> Phone char(15) NOT NULL,
17> FedIDNo varchar(9) NOT NULL,
18> DateInSystem smalldatetime NOT NULL
19> )
20> GO
1>
2> ALTER TABLE Customers
3> ADD CONSTRAINT CN_CustomerDateInSystem
4> CHECK
5> (DateInSystem <= GETDATE ())
6> GO
1>
2> drop table Customers;
3> GO
]]>