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 Trigger?

3 Answers   Misys,

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

How to store and query spatial data?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

Explain filtered indexes benefits?

0 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

What is triggers in ms sql server?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---