Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
|
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 4th, 2008, 01:57 PM
Registered User
 
Join Date: Sep 2008
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default Create XML file from SLQ Server2000 using vbScript

Hi all,

I would like to create an xml file from my sqlserver2000 tables using vbscript.

Can anyone help me ? This is the first time I work with xml.

Btw, I need to validate the xml file with an xsd file too.

Tks a lot!

 
Old September 5th, 2008, 02:32 AM
samjudson's Avatar
Friend of Wrox
 
Join Date: Aug 2007
Posts: 2,128
Thanks: 1
Thanked 189 Times in 188 Posts
Default

SQL Server 2000 contains commands to return select statements as XML - see the "FOR XML" command.

I'm not sure about the schema part however.

/- Sam Judson : Wrox Technical Editor -/





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create XML file - According to the Value, add elem remya1000 General .NET 0 October 2nd, 2007 11:03 PM
How to create and Save an Xml file at client side. kiranvsamuel XML 1 June 30th, 2006 05:26 AM
Create a new XML file with vbscript sswingle XML 4 April 24th, 2006 07:31 AM
Problem to create an xml file from two xml files saurabh_inblore XSLT 1 April 12th, 2006 02:58 AM
create xml file using c# kk_katepally General .NET 2 February 11th, 2005 02:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.