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 is the difference between upgrade and migration in sql server?

0 Answers  

---

How to modify the underlying query of an existing view?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

What are the recovery models in sql server 2000?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

What is the advantage of sql server?

0 Answers  

---

Find columns used in stored procedure?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What is row-level compre?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---