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 are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

what is lazy writer?

1 Answers   Wipro,

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

How can you append an identity column to a temporary table?

0 Answers  

---

What is field in algebra?

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---