Answer Posted / yashwanth

constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint

Where is localdb stored?

553

---

How do I port a number to sql server?

500

---

What are the advantages dts has over bcp?

524

---

How will you optimize a stored procedure optimization?

509

---

How to create a trigger for insert only?

597

---

---

What is a hint?

577

---

What is etl - extraction, transformation, and loading?

520

---

what is the information that can be stored inside a bit column? : Sql server database administration

516

---

Can we use max in where clause?

509

---

How to get nth highest salary from employee table.

613

---

What are recommended options to be used while using db mirroring? : sql server database administration

568

---

What are the tool windows in sql server management studio? : sql server management studio

617

---

How to use union to merge outputs from two queries together in ms sql server?

556

---

What are the differences between char and varchar in ms sql server?

572

---

What is save transaction and save point?

622

---