|
A column-level check constraint that limits Billings to positive amounts
A statement that defines the check constraint
11> CREATE TABLE Billings
12> (BillingID INT NOT NULL IDENTITY PRIMARY KEY,
13> BillingTotal MONEY NOT NULL CHECK (BillingTotal > 0))
14> GO
1>
2> --An INSERT statement that fails due to the check constraint
3>
4> INSERT Billings VALUES (-100)
5> GO
Msg 547, Level 16, State 1, Server J\SQLEXPRESS, Line 4
The INSERT statement conflicted with the CHECK constraint "CK__Billings__Invoic__6D230CE4". The conflict occurred in database "master", table "dbo.Billings", column 'BillingTotal'.
The statement has been terminated.
1>
2> drop table Billings;
3> GO
1>
|