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

what are the three command line utilities and what are their primary functions?

144

---

How to loop through the result set with @@fetch_status?

1311

---

What happens when converting big values to numeric data types?

1094

---

What is inner join in sql server joins?

1010

---

What are the purposes of floor and sign functions?

956

---

What are the different normalization forms?

1083

---

Tell me what is use of except clause? How it differs from not in clause?

934

---

How to check table values in sql server?

936

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1080

---

What is molap and its advantage? : sql server analysis services, ssas

965

---

How will you monitor replication latency in transactional replication? : sql server replication

1122

---

What are the advantages of using cte?

993

---

What are sub reports and how to create them?

137

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

998

---

What is difference between standardization and normalization?

1069

---