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:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (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.