Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table?

Answers were Sorted based on User's Feedback



How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the ..

Answer / soorai ganesh

If u Use SQLSERVER 2005. This will helpful to you


CREATE RULE myRule AS @strGrade IN('I','II','III','IV')
GO
CREATE TABLE myTable
(
empID INT,
empName VARCHAR(50),
empGrade VARCHAR(3),
empSalary NUMERIC(9,2)
);
GO
sp_bindrule myRule, 'myTable.empGrade';
GO


INSERT INTO myTable VALUES(1,'Ganesh','I',59000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','II',89000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','III',99000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','IV',259000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','V',259000) --
Invalid

Is This Answer Correct ?    12 Yes 0 No

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the ..

Answer / pervej

use constraint or rules that will helps u in this query
we can also use cursor for this for insert

Is This Answer Correct ?    0 Yes 0 No

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the ..

Answer / mohan

create table #test (sno int check(sno in(1,2,3)))

successfull statement:
insert into #test values(3)

failure statement :

insert into #test values(4)
error message:
INSERT statement conflicted with COLUMN CHECK
constraint 'CK__#test__sno__68E599B5'. The conflict
occurred in database 'tempdb',
table '#test________________________________________________
____________________________________________________________
___00000000D7E0', column 'sno'.
The statement has been terminated.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  


What do you think of this implementation? Can this be implemented better?

0 Answers  


what is the query and condition to delete datas in sql server.

2 Answers  


What is xml datatype?

0 Answers  


What is the purpose of data source?

0 Answers  


What is difference between group by and having?

0 Answers  


What are information schema views?

0 Answers  


Explain forward - only cursors?

0 Answers  


What is normalization according to you and explain its different levels?

0 Answers  


Which TCP/IP port does SQL Server run on?

2 Answers  


How do triggers work?

0 Answers  


How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  


Categories