Answer / ramachchandran

referencing:

ex: table A--> having primary key
table B--> having foreign key. now referencing means
this table B refers table A using the particular field u
mentioned as primary key and foreign key.

joining:
we can perform joining operation only if two table
have primary key and foreign key relationship. using this
keys we can perform inner, left outer,fullouter,right outer
joins.

diffrence between function and procedure

5 Answers   Wipro,

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

What is plan freezing?

0 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

Which is better statement or preparedstatement?

0 Answers  

---

What does dml stand for?

0 Answers  

---

explain query execution plan

1 Answers  

---

What is a database in ms sql server?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

What are the pre-defined functions in the sql server?

0 Answers  

---