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
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
what changed between the previous version of sql server and the current version? : Sql server database administration
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Explain the first normal form(1nf)?
What are the types of dml?
What causes index fragmentation?
What is the default fill factor value?
How can we improve performance by using SQL Server profiler?
Explain features of analysis services?
Define normalisation?
explain different levels of normalization? : Sql server database administration
Define self join in sql server joins?
How do you identify a foreign key?
What is the difference RDBMS and Graph Database?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?