CREATE TABLE [dbo].[ACCOUNT](
	[ACCOUNT_ID] [int] NULL,
	[ACCOUNT_LOCATION] [varchar](10) NULL,
	[CUSTOMER_ID] [int] NULL,
	[CHECK_IN_AMT] [int] NULL,
	[SAVINGS_AMT] [int] NULL
)

CREATE RULE Amount_rule  
AS   
(@CHECK_IN_AMT >= 1000)  

EXEC sp_bindrule 'Amount_rule', 'account.CHECK_IN_AMT'

ALTER TABLE ACCOUNT
ADD CONSTRAINT cc_MinBal
CHECK (CHECK_IN_AMT > 800);

insert into account([CHECK_IN_AMT]) values (100)