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

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

Can two tables share a primary key?

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

What is stored procedures?

0 Answers  

---