SQL Server constraint

CHECK constraint

A CHECK constraint can be applied to a column in a table to limit the values that can be placed in a column. Check constraint is to enforce integrity.

After this if we used to insert the following query

insert into employees values(0,'Sawan','Chauan',24567)

Then following Output Message will be diplayed.

Second Example of Query

When we try to insert the following -

Then we will receive the above error

TRY----CATCH constructs

To handles exceptions by writing scripts inside the TRY block and error handling in the CATCH block