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 to generate create procedure script on an existing stored procedure?

0 Answers  

---

What is model database? : SQL Server Architecture

0 Answers  

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

How many cores do I need for sql server 2016?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

How do I shrink an ldf file?

0 Answers  

---

How to assign new column names in a view?

0 Answers  

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

What is log shipping?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

What are acid properties of transaction?

0 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---