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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me the difference between clustered and non-clustered index?

680


What is the difference between indexing and hashing?

751


What is SQL Azure Federations?

106


what stored procedure would you use to view lock information? : Sql server administration

743


Can a database be shrunk with users active?

797






Explain about unique identifier data type in sql server?

679


Can we take the full database backup in log shipping?

717


How to get a list of columns in a view using the "sp_help" stored procedure?

784


What are the purposes and advantages stored procedure?

683


What is an indexing strategy?

705


Explain different forms of normalization?

685


Mention the differences between sql server and mysql.

680


What are the types of joins in sql?

773


Explain what is the function of sql server agent windows service?

703


How dts is used to extract, transform and consolidate data?

789