Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between referencing and joining?
- 1 Answers
- 4221 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 executereader?
Call by value and call by reference in procedure and function, with NOCOPY.
Explain about SQL server 2005?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What number sorts of privileges are accessible in sql?
Which language is supported by sql server?
How to recreate an existing index in ms sql server?
How to list all user names in a database?
How you can move data or databases between servers and databases in sql server?
What are some examples of schemas?
What is service broker? : sql server database administration
Do you know how to implement service broker?
What is difference statement and preparedstatement?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is use of except clause? How does it differ from not in clause?
