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.

syntax for deleting the database in T SQL

5 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Should you normalize audio?

0 Answers  

---

What are the advantages of using third-party tools?

0 Answers  

---

Explain the truncate command?

0 Answers  

---

What is rtm version in sql server?

0 Answers  

---

How to insert stored procedure result into temporary table?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

What is partition in sql server?

0 Answers  

---

What happens if time-only values are provided as date and time literals?

0 Answers  

---