--- Calculated Column ---
Drop Table EMP

Create Table EMP
(
EMP_ID int primary key,
Salary money not null Constraint CK_ZERO check(Salary > 0),
Bonus money not null Constraint CK_BONUS check(Bonus < 500),
FinalPayment as Salary + Bonus
)

Insert Into EMP (EMP_ID, Salary, Bonus)
Values(1, 10000, 499)

select * from EMP

Insert Into EMP
Values(2, 9000, 100)

select * from EMP