What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Some queries related to SQL

0 Answers   Motorola,

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

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

0 Answers  

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

How do I start sql server 2017?

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---