Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between referencing and joining?
- 1 Answers
- 4215 Views
- I also Faced
- E-Mail Answers
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 |
What is the default schema of your login session in ms sql server?
What is sql language?
How to return the second 5 rows in ms sql server?
Explain syntax for viewing trigger?
What are the events recorded in a transaction log?
How to populate a table in sql server?
Why use update_statistics command in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How many types of stored procedures are there in sql server?
How to retrieve data from log files in SQL SERVER ?????
What is the correct order of the logical query processing phases?
What do you mean by an execution plan? How would you view it?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
