Answer / mahendra raja

select * from [table name] for xml auto (or)
select * from [table name] for xml raw

But if there is any binary field column in table then this
query wont work.

What are the different type of replication in sql server?

0 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

What is difference between order by and group by?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

What is sql collation?

0 Answers  

---

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

Explain indexed views?

0 Answers  

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---