Bikash Kumar Ray

SQL and ASP.net Related Practical Problems

Wednesday, May 19, 2010

Create XML File from Query

1) SELECT remarkid,remark FROM callstatus FOR XML RAW

2) SELECT remarkid,remark FROM callstatus FOR XML AUTO

3)SELECT remarkid,remark FROM callstatus FOR XML path
Select 3rd query and press Ctrl+D and then run the query
Posted by Unknown at 2:35 AM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

Unknown
View my complete profile

Blog Details

  • ►  2013 (6)
    • ►  November (1)
    • ►  June (1)
    • ►  February (4)
  • ►  2012 (4)
    • ►  October (1)
    • ►  May (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  July (1)
    • ►  May (1)
    • ►  April (4)
  • ▼  2010 (13)
    • ►  September (1)
    • ►  August (5)
    • ►  July (2)
    • ▼  May (1)
      • Create XML File from Query
    • ►  February (4)
  • ►  2009 (38)
    • ►  December (5)
    • ►  November (4)
    • ►  October (2)
    • ►  September (3)
    • ►  August (4)
    • ►  July (5)
    • ►  June (6)
    • ►  May (3)
    • ►  April (6)

Worked Websites

  • eDMS
  • Plyreporter
  • Tour and Travel Website
  • Tradeget
Ethereal theme. Powered by Blogger.