What is the difference between referencing and joining?
- 1 Answers
- 3630 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is stored in the mssqlsystemresource database? : sql server database administration
Why people hate cursor?
How do I open port 1433?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
How do you create an execution plan?
What is checkpoint in sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to convert binary strings into integers in ms sql server?
How to insert multiple rows with one insert statement in ms sql server?
Can we take the full database backup in log shipping?
How do you send email on SQL Server?
What is role playing dimension with two examples? : sql server analysis services, ssas
Explain tables in SQL Azure?
What are the mathematical functions supported by sql server 2005?
List some of the rules that apply to creating and using a ‘view’
