Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between referencing and joining?
- 1 Answers
- 4097 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
Do you know how to implement service broker?
Explain about Normalization?
What is the default server name for sql server?
In what version of sql server were synonyms released?
How to delete existing triggers using "drop trigger"?
How to provide values to stored procedure parameters in ms sql server?
Do you know clustered and non-clustered index?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the Difference Between Primary and Foreign Key?
What is check constraint in sql server?
What functions can a view be used to performed?
What are advantages of ssrs or why we should use ssrs?
how can a database be repaired? : Sql server administration
What happens if null values are involved in string operations?
What is the difference between having clause and where clause in sql server?
