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 are the diifferences between the ms sql server vs mysql?

0 Answers  

---

What is the default server name for sql server?

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

syntex of insert

7 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

Explain nested join?

0 Answers  

---

What is the stuff?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

What is analysis service repository?

0 Answers  

---

Explain indexing and what are the advantages of it?

0 Answers  

---