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

Answer / chaitu

These are contraints

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is collation sensitivity? Explain different types.

0 Answers  

---

What are the advantages of policy management?

0 Answers  

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

---

Is truncate a dml command?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

What does it mean to invest in the index?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

what is a mixed extent? : Sql server administration

0 Answers  

---

Explain unique key in sql server?

0 Answers  

---