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 system databases into sql server (2005/2008)?

952

---

How do you manipulate data?

848

---

How to make remote connection in database?

953

---

You want to use a perspective in an mdx query. How do you select the perspective?

229

---

What are logical database components? : SQL Server Architecture

958

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1043

---

What are the restraints imposed on the table design by a merge replication?

981

---

What is mssql?

926

---

How to apply cascading referential integrity in place of triggers?

965

---

Mention the differences between substr and charindex in sql server.

982

---

Can we call future method from trigger?

877

---

Explain “row_number()” in sql server with an example?

947

---

What are the different types of columns types constraints in the sql server?

1004

---

List the various tools available for performance tuning?

842

---

What is a trace frag? Where do we use it?

1043

---