What is the difference between referencing and joining?
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
How to delete duplicate rows?
Mention the uses of stored procedures.
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is a group function explain with an example?
What triggers long term care?
How to write character string constants or literals in ms sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the exact numeric data type in sql?
How to create function with parameter in sql server?
How to find table changes in sql server?
What is the size of transaction log file?
In which tcp/ip port does sql server run? Can it be changed?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the maximum size of sql server database?