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.

What functions can a view be used to performed?

1049

---

How do you debug a procedure in sql server?

923

---

What is store procedure?

1040

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

906

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1023

---

What are the differences between char and nchar in ms sql server?

1059

---

What is an index. What are the types?

1057

---

What is nonclustered index with included columns ?

945

---

What are the different types of sql server replication? : sql server replication

1234

---

How to see existing views in ms sql server?

1020

---

What is instead of trigger sql server?

977

---

Explain the concepts and capabilities of sql server?

952

---

How can I create a new template for import ? : sql server management studio

1052

---

What are partitioned views?

966

---

between cast and convert which function would you prefer and why?

939

---