Check , Default, in SQL Server

your always welcome bineesh

Thanks a lot Mr.Pankaj Pandey for helping me.

Thank You all for the Reply .

Your replays are more valuable for me.

Hi Bineesh, 

As Pankaj has already mentioned the code to create it, use it, it's absolutely fine and works.

If you want to later your table, use the code below:

alter table tbl_Class
add constraint ck_id check (classid>0 and classid<6)

Hope it helps :)
Thanks.

try the code that i have given.


why you are using  procedure when it is possible with table?

anyway, if any other confusion then ask here.

you are using incorrect syntax that i think..may be i am wrong..but my query is working perfactly.


try it and give responce that are you helped with these query otherwise give some detail that what you want exactly and what you done.

ALTER PROCEDURE  ClassAlter
AS

classId int not null,
className nvarchar(50) default ' Class1',
Dates datetime,
check(classId between 1 and 5)

hello

what the query you are using, share here, 
i'll try to correct it.