Answer / koteshwar rao .palleboina

when foreign key constraint is created on a column
referential integrity is achieved .
when foreign key constraint is created on a column,that
column reference other column in the different table or
even in the same table but the reference column must be
primary key or unique key.
when a new value is added in a column referenced with
foreign key ,then the foreign key relation checks whether
the new value matches with the reference column or not.
If value matches then they are allowed into the table

Difference between drill down and drill through report.

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

What is instead of trigger sql server?

0 Answers  

---

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

---

What do you mean by sql server agent?

0 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

What is an execution plan?

0 Answers  

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

---