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
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 |
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 |
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 |
How do I shrink an ldf file?
How do I partition a table in sql server?
What is the difference between constraints and triggers?
What is collation?
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj
Explain “@@rowcount” and “@@error” in sql server?
Is mysql the same as sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Does sql server use t sql?
Explain the database you used in your final year project?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
How to generate create function script on an existing function?