Answer Posted / amit dixit

Just Above is OK except UNION ALL result modified..
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth

Result Set:
UNION: First,Second,Third,Fourth,Fifth,Sixth (This will
remove duplicate values)
UNION ALL:
First,First,Second,Second,Third,Fourth,Fifth,Fifth,Sixth
(This will repeat values)

How self join is different from outer join?

1121

---

What is RAID? What are the different types of RAID configurations?

1136

---

how can you check the level of fragmentation on a table? : Sql server administration

984

---

Why I have to use stored procedures?

1050

---

Can you explain about buffer cash and log cache in sql server?

949

---

Why normalization is used?

1013

---

How to manipulate data from one table to another table ?

969

---

What are the advantages to use stored procedures?

1110

---

What types of replication are supported in sql server?

1063

---

How to execute stored procedure in select statement sql server?

1062

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

---

What is executereader?

953

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1057

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

971

---

What is the difference between grant and with grant while giving permissions to the user?

965

---