query output as XML
Hi
Can I have my query output returned as XML (FOR XML AUTO) in SQL Mobile ?
thanks
Bruce
[112 byte] By [BruceBaker] at [2008-2-12] 
«« Adding users to [project]Contributors: Cannot access users/groups in domain
»» TF30290: There was a problem accessing the database on the server. See the Team Foundation Serve
»» TF30290: There was a problem accessing the database on the server. See the Team Foundation Serve
no, not directly from SQL Mobile. you can fill a DataSet with your query results using the adapter or data reader and then convert the DataSet into XML....
-Darren
DarrenShaffer at 2007-10-6 >
SQL Server Hot Topic
- Generate Scripts option in SQL 2005 Management Studio
- xQuery requires QUOTED_IDENTIFIER
- view ignoring order by - used to work in sql 2000
- Export Data to MS Access file
- "Begins With" Filter in Report Builder?
- SQL Server Express Security?
- Passing connection managers to subpackages.
- Sql EX 05 can't view dB and Tables
SQL Server New Topic
- Access Exchange mail & attachments
- Matrix reports & MDX Hierarchies
- Unexpected Results with "Rolling 12 Month Sales" Calculated Member
- SSMS presentation of IS Packages...
- Not able to view the Drill down section in the Report Manager
- ANN: Version 2 of Reporting Services Scripter now available
- Error when calling a Java (ws4ee) web service
- VB 2005 & Small Business Server & SQL Server
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc