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

Expand|Select|Wrap|Line Numbers

 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

Query

re: Query

re: Query

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about