Answer / Ziaul Qamar

A join is a SQL operation that combines rows from two or more tables based on a related column between them.

What are the types of constraints?

1 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1 Answers  

---

What is the difference between truncate and delete commands?

1 Answers  

---

What is delete query?

1 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

What is extended stored procedures?

1 Answers  

---

wat wil hapn if we give the both read and deny read permission to user?

1 Answers   IBM,

---

What functions can a view be used to performed?

1 Answers  

---

How to write a query with a right outer join in ms sql server?

1 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

1 Answers   HCL,

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

What are group functions in query statements in ms sql server?

1 Answers  

---