load/read/import XML file in SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Pavel (pavel.ermol_at_bluewin.ch)
Date: 07/29/04

  • Next message: Graeme Malcolm: "Re: XML to SQL Server table" 
    Date: 28 Jul 2004 22:35:15 -0700

    Hello

    Is it possible to create database in SQL Server 2000 from XML file
    directly
    (load/read/import XML file in SQL Server) supposing that in SQL Server
    there is no database corresponding to XML database.
    Or one must do first of all some preparative work (create database in
    SQL Server with corresponding tables) and then proceed with XML file.

    Thanks in advance.

    Pavel.

  • Next message: Graeme Malcolm: "Re: XML to SQL Server table"

    Relevant Pages

    • Re: Securing a web DB
      ... >name, uid, password) from an XML file and establish connection to the DB. ... >We are planning to host the site with as ISP. ... >integrated login) for the database. ... >get to know the SQL server password. ...
      (comp.security.misc)
    • Re: where shoule store the questions and answers
      ... You can use the text file, a XML file or a database (Access, SQL Server ... design and document much faster: ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Securing a web DB
      ... >We are putting up a ASP.NET based web site using SQL Server database. ... >name, uid, password) from an XML file and establish connection to the DB. ...
      (microsoft.public.sqlserver.security)
    • load/read/import XML file in SQL Server 2000
      ... Is it possible to create database in SQL Server 2000 from XML file ... supposing that in SQL Server ...
      (microsoft.public.sqlserver)
    • load/read/import XML file in SQL Server 2000
      ... Is it possible to create database in SQL Server 2000 from XML file ... supposing that in SQL Server ...
      (microsoft.public.sqlserver.ce)