Answer / Faisal Wasi

A sub-query (also known as nested query) in SQL Server is a SELECT statement that is nested within another SELECT, DML (Data Manipulation Language), or DDL (Data Definition Language) statement. It allows for retrieving data from one table based on the results of a query executed against another table.

How to concatenate two binary strings together?

1 Answers  

---

How do you set a trace flag in sql server?

1 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

What is the difference between dataadapter and datareader?

1 Answers  

---

Explain the difference between delete,drop and truncate in SQL Server?

1 Answers   HCL,

---

From where can you change the default port?

3 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

How to provide login information for a new odbc dsn?

1 Answers  

---

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  

---