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

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

What is sql server management studio? : sql server management studio

0 Answers  

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

---

Can we insert data into a view?

0 Answers  

---

Differentiate between a primary key and a unique key.

0 Answers  

---

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---