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

How global temporary tables are represented and its scope?

966

---

What command is used to rename the database?

1003

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

975

---

What is the new security features added in sql server 2014? : sql server security

991

---

How to create an inline table-valued function?

959

---

What are dml triggers and types of dml triggers?

970

---

What causes index fragmentation?

988

---

How do I find sql server instance name?

953

---

What is the sql case statement used for?

1087

---

How to create function with parameter in sql server?

1095

---

What is ddl and dml commands?

898

---

What is store procedure?

1049

---

What is the difference between char, varchar and nvarchar?

1019

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1178

---

Tell me what is the order in which the sql query is executed?

942

---