Answer / Neha Gautam

{"union": {"description": "The UNION operator combines the result sets of two or more SELECT statements and eliminates duplicate rows based on a common column."},"union all": {"description": "The UNION ALL operator also combines the result sets of two or more SELECT statements but does not eliminate any duplicate rows."}}

How to Get the last identity value used

4 Answers  

---

What are scheduled tasks in sql server?

1 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is updatable resultset?

1 Answers  

---

Why transaction is important?

1 Answers  

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

What is a transactions?

1 Answers  

---

What does asynchronous call backs means?

1 Answers   Alcatel-Lucent,

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

i want table name basis on column name.

5 Answers  

---

What command do we use to rename a database?

1 Answers  

---