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.

Explain what are sparse columns?

0 Answers  

---

How do I start sql server 2016?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

What is data source document?

0 Answers  

---

Explain mixed authentication mode of sql server?

0 Answers  

---

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

Why are sql functions used?

0 Answers  

---

What do you understand by a view?

0 Answers  

---

What does it mean to be in union?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

What are the different types of join?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---