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)

How to execute a sql statement using odbc_exec()?

1057

---

How many tables can be joined in SQL Server?

1004

---

how to overcome kernel isssues

1567

---

What are different types of statements that are supported by sql?

981

---

What is join query?

837

---

What do you understand by recursive stored procedures?

938

---

What is the difference between ddl and dml?

1003

---

What is difference between unique and primary key?

854

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1326

---

How will you hide an attribute? : sql server analysis services, ssas

891

---

What is the difference between indexing and hashing?

1078

---

What is the simplest way to create a new database in ms sql server?

954

---

What is difference between Datepart() and Datename() in SqlServer?

1157

---

What are cascading parameters in ssrs reports?

212

---

Explain the properties of subqueries in sql server?

1017

---