Get data in table as XML, return each column as element instead of attribute
SELECT CustomerID, CompanyName
FROM Customers
FOR XML AUTO, ELEMENTS
Thursday, November 26, 2009
Get table data as XML
Subscribe to:
Post Comments (Atom)
About Me
- タオ チューン
- I love information system such as ERP, CRM, SCM, HRM, Accounting, etc very much and would like to share my knowledge about ERP, CRM, HRM, SCM, ... which I knew to everyone.
Popular Posts
-
The following query gets vtigerCRM Contact List SELECT t1.contact_no , t1.firstname , t1.lastname , t1.title , t4.accountname , ...
-
1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ...
-
You have two SQL Server 2005 computers. One server is SQL1 and another is SQL2. You need to access SQL2 from SQL1. You have enough permissio...
-
If you want to use a single query to replace multiple spaces with one on SQL Server, you can read the articles here http://www.sqlservercent...
-
Go to Pligg website to learn more. CREATE TABLE `pligg_comments` ( `comment_id` int(20) NOT NULL auto_increment, `comment_randkey` i...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
-
If the stored procedure is not encrypted , you can use this extended stored procedure: sp_helptext 'StroreProcedureName' You can fin...
-
What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
-
SELECT name, context, unit, setting, short_desc FROM pg_settings WHERE name in ('listen_addresses' ,'max_connections'...
-
Life Quote : The difficulties, hardships and trials of life, the obstacles...are positive blessings. They knit the muscles more firmly, and ...
No comments:
Post a Comment