The following warnings occurred:
Warning [2] Cannot modify header information - headers already sent by (output started at D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\scripts.php:2) - Line: 1701 - File: D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php PHP 5.2.17 (WINNT)
File Line Function
[PHP]   errorHandler->error
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php 1701 header
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php 1763 my_setcookie
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions_indicators.php 42 my_set_array_cookie
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\showthread.php 578 mark_thread_read
Warning [2] Cannot modify header information - headers already sent by (output started at D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\scripts.php:2) - Line: 1701 - File: D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php PHP 5.2.17 (WINNT)
File Line Function
[PHP]   errorHandler->error
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php 1701 header
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions.php 1763 my_setcookie
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions_indicators.php 218 my_set_array_cookie
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\inc\functions_indicators.php 48 mark_forum_read
D:\inetpub\vhosts\visionwebdirectory.com\httpdocs\forum\showthread.php 578 mark_thread_read





Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Returning data in XML format in SQL server 2008
06-30-2013, 07:07 PM
Post: #1
Returning data in XML format in SQL server 2008
Many times we need to convert our data in XML format. The below query will return you the data in XML format directly from database:

SELECT col1, col2 FROM TableName FOR XML PATH('data'), TYPE

This will return you the following data:

<data>
<col1>1</col1>
<col2>Data Entry</col2>
</data>
<data>
<col1>2</col1>
<col2>Data Entry Test dev</col2>
</data>
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)