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 extra roles available in msdb? : sql server security

0 Answers  

---

What are the types of indexes?

0 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

What is rtm version in sql server?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

What is the distinction amongst delete and truncate?

0 Answers  

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

What is difference between materialized view and view?

0 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

Can select statements be used on views in ms sql server?

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---