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.

Why we need sql server?

1008

---

Why are sql functions used?

1181

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

1027

---

List the different types of collation sensitivities in sql server?

1074

---

Why use stored procedures in sql server?

1057

---

what are defaults? : Sql server database administration

1159

---

Explain what is log shipping?

1191

---

What are triggers? How do you invoke a trigger on demand?

1362

---

How do you create a data source?

959

---

What is cdc in sql server?

1043

---

What are the joins in sql server? : sql server database administration

1050

---

What is the difference between ddl,dml and dcl commands?

1153

---

Define self join?

1075

---

What are different types of database indexes?

1165

---

What is store procedure?

1111

---