Check , Default, in SQL Server

May 30 2013 7:36 AM

Sir, I am doing a SQL Query at the moment.

I have a Table named tbl_Class

it have three parameters:- classId(int),className(nvarchar(50),Dates(datetime).

i can't make CHECK Constraint for classId( between 1 and 5) and DEFAULT Constraint for className('FirstClass')

Please Help me.