Answer Posted / ramesh.n

constraints are the restrictions or limitations that are
being imposed on the columns of a table to validate the data
either for insertion or updation constraints can be imposed
either during the process of table creation of a level.

There are 8 types of constraints
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
7.composite primary key
8.composite unique key

Explain identity in sql server?

1013

---

How to connect to a sql server using odbc_connect()?

1155

---

Write an sql query for deleting duplicate rows?

996

---

what are the critical issues you have resloved in your company

1964

---

What is the parse query button used for?

1038

---

What are the filtered indexes?

1040

---

What are user-defined functions (udfs) in sql server?

990

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1059

---

What are the different types of stored procedures?

1117

---

Define inner join in sql server joins?

1061

---

Explain various On-Delete options in a DB table. Which is the default option?

1468

---

How can we determine what objects a user-defined function depends upon?

1014

---

What is a non-clustered index?

998

---

What is the use of tempdb? What values does it hold?

1072

---

How to create database with physical files specified in ms sql server?

996

---