Website Design United States, Website Design California, Website Designing United States, Website Designing California

Query Results as XML rather than standard rowsets - SQL

Note-This Clause is valid only in the SELECT and not valid in COMPUTE BY or FOR BROWSE, view definition , cursors and for further processing in a stored procedure

some times we need the result of the query in xml format. so that we can use the output directly in the code.

USE pubs
SELECT type,
price,
advance
FROM titles
FOR XML AUTO

WEB DESIGN INDIA
42 B Malviya Nagar , New Delhi-110017

Skype: manmeetsi
Email: support.webdesignindia@gmail.com
Tel: 91-011-40502005, 9810067295

 















 


© 2008-2009 dotnet4all.com