Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

How and why use sql server?

753

---

Explain the usage of floor function in sql server.

725

---

Do you know what is normalization of database? What are its benefits?

789

---

What is the difference between count and distinct count?

671

---

What is a data source or ds? : sql server analysis services, ssas

808

---

What is mssql?

760

---

plss anybody specify tha constrian management system in dbms

1870

---

What are the purpose of Normalisation?

844

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

837

---

What is scrollable cursor?

802

---

Tell me what is use of except clause? How it differs from not in clause?

745

---

What are key constraints?

756

---

What is the difference between deallocate cursor and close cursor?

955

---

What is logon trigger?

783

---

Can an entity have two primary keys?

754

---