Answer / Mohammad Arif

The types of constraints in SQL Server are:
1. Primary Key
2. Foreign Key
3. Check Constraint
4. Unique Constraint
5. Default Constraint

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1 Answers  

---

How you can get the list of largest tables in a database?

1 Answers  

---

Is sql server a database?

1 Answers  

---

What is an identity?

1 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

When a primary key constraint is included in a table, what other constraints does this imply?

1 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

What do you do in data exploration

1 Answers   EXL,

---

How do you create type- insensitive operator?

1 Answers   EXL,

---

how to delete duplicate rows from table

9 Answers   CSC,

---

What is the difference between Stored Procedures and triggers?

1 Answers   HCL,

---