Answer Posted / vijaya

Constraints are rool of data integrity.

Types of Constraints are:
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References.

How to remove duplicate rows from table?

614

---

How would you use user_constraints table in DB?

600

---

What is set nocount on?

511

---

What is query processing?

549

---

Tell me about builtinadministrator?

570

---

---

When I run the sql server 2000 setup, it just hangs. What do I do?

658

---

What objects does the fn_my_permissions function reports on? : sql server security

567

---

how we use window authentication connection with sql server.?

637

---

What do you understand by a stored procedure?

620

---

What is 2nf normalization?

550

---

what is the difference between count(*) and count(1) ?

635

---

How do I run a trace in sql server?

515

---

How to round a numeric value to a specific precision?

577

---

what are database files and filegroups? : Sql server database administration

505

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

539

---