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.

what is a self join? : Sql server database administration

0 Answers  

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

Define a cross join?

0 Answers  

---

What are acid properties of transaction?

0 Answers  

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

Psudo colums

1 Answers   HP,

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---