Answer Posted / aravindu chowdary

CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table





* Primary key : Ensure no duplicate data and not allow
nulls.

3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values

Determine when to use stored procedure to complete sql server tasks?

988

---

What are group functions in query statements in ms sql server?

951

---

What are the types of table?

921

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2029

---

What is a collation?

1038

---

Explain timestamp datatype?

913

---

What is a primary index?

885

---

Explain the ways to controlling cursor behavior?

876

---

What are the different index configurations a table can have?

901

---

If the job running very slow what is the action you do

1828

---

How is foreign key related to primary key?

916

---

What will be the maximum number of index per table?

955

---

How to bind a view to the schema of the underlying tables?

947

---

How do I find the sql server database version?

942

---

What is "scheduled jobs" or "scheduled tasks"?

915

---