Answer / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Answer / jagadeesh b

If you maintain this relation ship you can get more advantages

1)you can not delete primary table directly..

2)duplicate values are not allowed in primary key table.

3)Null values are not inserted into primary key table so
validation is very easy fro m front end.(for ex; .net 2005).

Answer / deepak

1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.

Answer / rajendraprasad cherukuri

To segregate the data in different tables belongs to a
particular entity so that data can be retrieved when
required more economically and in a faster way.

When would you prefer to have a minimum number of indexes?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

Explain indexes disadvantages?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What is b tree index?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What are the hotfixes and patches in sql server?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---