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.

How extra digits are handled with numeric data type literals?

0 Answers  

---

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

0 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

What is indexed view?

0 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---