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 sub query and its properties?

0 Answers  

---

What is acid mean in sql server?

0 Answers  

---

What is msdb database? : SQL Server Architecture

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

Explain the xml support sql server extends?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---