Check Default in SQL Server

Question

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.

Pankaj Pandey · Answer

hello bineesh i have created a query and checked it  it works properly try it. create table tbl_class ( classId int  className nvarchar(50) default 'FirstClass' Dates datetime CHECK (classId >0 and classId ) insert into tbl_class values(10'fsdf'getdate()) not inserted insert into tbl_class (classIdDates ) values(1getdate()) inserted data inserted== classId className Dates 1 FirstClass 2013-05-30 17:19:27.937

Pankaj Pandey · Answer

your always welcome bineesh

Bineesh VP · Answer

Thanks a lot Mr.Pankaj Pandey for helping me.

Bineesh VP · Answer

Thank You all for the Reply . Your replays are more valuable for me.

Sunny Sharma · Answer

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 Hope it helps :) Thanks.

Pankaj Pandey · Answer

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.

Bineesh VP · Answer

ALTER PROCEDURE ClassAlter AS classId int not null className nvarchar(50) default ' Class1' Dates datetime check(classId between 1 and 5)

Pankaj Pandey · Answer

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

Check , Default, in SQL Server