Query

[krvmadhu]

I want to insert some particular values to a table

for ex:
In a table for a column i want to insert only values from 1,2,3,4,5.It sholud not allow to enter 6,7.... or any value

[ziycon]

Are you doing this directly on the database or through an application/website?

[ssnaik84]

You can create a check constraint

create table testrule
(srno int)

ALTER TABLE testrule 
ADD CONSTRAINT myconstraint CHECK (srno LIKE '[1-5]' );

insert into testrule values (2)
insert into testrule values (7)

select * from testrule