Answer Posted / nikhila reddy

UNION:the both tables should have same structure and datatype.
the column name will taken as first table ones it wont bother abt other tables.
example:
emp table as
eid ename esal
1 a 10k
2 b 20k

dept table as
deptid deptname deptsal
11 aa 20k
12 bb 50k


select * from emp
union
select * from dept

empid empname empsal
1 a 10k
2 b 20k
11 aa 20k
12 bb 50k

now u can observe col name taking alias of first table.
no need of relation between a tables.
it will remove duplicate records.


joins:it will join only required fields from different tables.
no need of same structure for tables..
it should have relation between a tables.

How do you migrate data from mssql server to azure?

165

---

How do I view a trc file?

944

---

Where to find ntwdblib.dll version 2000.80.194.0?

962

---

What command is used to create a database in the sql server and how?

1182

---

What are a scheduled jobs or what is a scheduled tasks?

903

---

What are a database and a data warehouse?

1023

---

How to remove duplicate rows from table?

1253

---

What are the 10 characteristics of data quality?

956

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1052

---

What are the basic features of a trigger in ms sql server?

1199

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

994

---

How to convert a unicode strings to non-unicode strings?

1103

---

What is bcnf normalization form?

1120

---

What happens if null values are involved in datetime operations?

976

---

What are the limitations in ssrs on sql server express edition?

186

---