Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to generate XML out of QUERY?

Answer Posted / 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.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if you are trying to access a schema not owned by you?

956


What is etl - extraction, transformation, and loading?

902


What are the advantages of policy management?

982


Explain how to maintain a fill factor in existing indexes?

979


Explain what are commit and rollback in sql?

911


What are subqueries in sql server? Explain its properties.

996


What is reference section?

985


What the class forname () does?

1034


What do you mean by normalisation?

1015


Explain alternate key, candidate key and composite key in sql server?

895


How to filter out duplications in the returning rows in ms sql server?

1116


How to connect php with different port numbers?

1061


What happens if null values are involved in datetime operations?

956


How to find the list of fixed hard drive and free space on server?

1162


What is difference between aggregate and analytic function?

906