Answer / reva ram sahu

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

---

Explain activity monitors

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

Explain use of expression builder.

0 Answers  

---

What is co-related sub query?

0 Answers  

---

How to insert stored procedure result into temporary table?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---