Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / samba shiva reddy . m
Full Outer join it will take all the records from the both the tables.
Example:
Table1 : emp
______________
empid empname
______________
1 samba
______________
2 Anju
______________
NULL Shiva
______________
5 NULL
______________
Table2 : user
______________
uid uname
______________
1 raju
______________
2 Khan
______________
3 Sripal
______________
4 Sathosh
______________
NULL Srinu
______________
9 NULL
______________
We will write the Full Outer join on both the table
Select * from emp full outer join [user] on emp.empid=[user].uid
the result will be both the tables with NULL vslues
but in the cross join it is bsed on the rows
in the cross join it will give the combination of all rows
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you delete duplicate records in sql server?
Do you know what is rank function?
Can select statements be used on views in ms sql server?
What command do we use to rename a db, a table and a column?
What is resource db in sql server?
What are the results of running this script?
What is an example of a primary key?
What is the process of normalization?
How to deploy the Report?
How to grant a permission in ms sql server using "grant execute" statements?
What is transactional replication?
Explain about Views?
What are the properties of the transactions?
What protocol does sql server use?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
