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
-
If the stored procedure is not encrypted , you can use this extended stored procedure: sp_helptext 'StroreProcedureName' You can fin...
-
1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ... -
SELECT name, context, unit, setting, short_desc FROM pg_settings WHERE name in ('listen_addresses' ,'max_connections'... -
The following query gets vtigerCRM Contact List SELECT t1.contact_no , t1.firstname , t1.lastname , t1.title , t4.accountname , ...
-
Go to Pligg website to learn more. CREATE TABLE `pligg_comments` ( `comment_id` int(20) NOT NULL auto_increment, `comment_randkey` i...
-
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...
-
Better Decisions with Smarter Data | MIT Sloan Management Review : Accurate – data must be what it says it is with enough precision to dr...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
-
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...
-
Find employees have salary greater than maximum salary in 'IT' department SELECT ENAME, JOB, HIREDATE FROM EMP WHERE SAL > ( SELE...
No comments:
Post a Comment