Answer Posted / samy

Union:
combine two tables and common values to be retrieved no
duplicate values

Union All:

All the values to be retrieved when combine two table.
(duplicate values)

What is the difference between system objects and user objects?

1159

---

What to check if a User database is locked?

1071

---

What is abstracting periodical?

946

---

Does partitioning improve performance?

975

---

Does a sql server 2005 select statement require a from?

1020

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

929

---

What is the maximum length of an alert name?

1001

---

Can a database be shrunk with users active?

1133

---

Can truncate be rolled back?

946

---

What are truncate options available in sql server? : sql server database administration

1030

---

How do you delete duplicate rows in sql server?

956

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1039

---

How to Sync Two SQL Azure Databases?

121

---