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 use of expression builder.

0 Answers  

---

Explain the different types of backups available in sql server? : sql server database administration

0 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

What is pessimistic concurrency?

0 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is a primary key?

0 Answers  

---

Can a trigger be created on a view?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---