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
What is nonclustered index with included columns ?
What is a schema in ms sql server 2005?
What is a bit datatype?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
can a table be moved to different filegroup? : Sql server administration
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How to delete database objects with "drop" statements in ms sql server?
What is ms sql server reporting services?
What are the advantages of sql stored procedure?
What are rest-style architecture's?
What is optimization and its types?
Where do you find the default Index fill factor and how to change it?
‘Order by’ is not allowed in a view how can you sort information from a view?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain system scalar functions?
