Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prasanthi
Check Constraint:
The CHECK constraint is used to limit the value range that
can be placed in a column.
not null constraint:
if we give not null constraint to any column it will not
accept null values.
Unique Conatraint:
Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Define cursor locking
How to write a query with an inner join in ms sql server?
What is difference between rownum and rowid?
How to find the second highest salary of an employee?
In what sequence sql statement is processed?
What do you know about system database? : SQL Server Architecture
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
When would you use a before or after trigger?
Which are the new data types introduced in sql server 2008?
How do I find the query plan in sql server?
Mention what are the core components of ssrs?
What is executereader?
Does any body please help me what question's have asked for SSRS in the interview?
What is the purpose of object explorer and its features? : sql server management studio
Is sql server difficult to learn?
