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's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

What is always encrypted?

0 Answers  

---

How do I run sql server 2014?

0 Answers  

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

How to sort query output in descending order in ms sql server?

0 Answers  

---

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

0 Answers  

---

What is the difference between char, varchar and nvarchar?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---