using xml format to import data to sql 2k

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

1. Instead of text delimiter, an xml format data could imported to sql 2k
tables?
2. The same way import text files? --fast and less resource? what is the
benefit of using xml instead of T-sql
3. How do I generate an xml format table schma?

Thanks


.

Relevant Pages

  • Re: Recordset to XML
    ... recordset in XML format. ... Chris Hanscom - Microsoft MVP ... Veign's Resource Center ... > I need to convert a VB6 ADO Recordset to XML so that it can be serialized ...
    (microsoft.public.vb.database.ado)
  • Dataset or SqlCommand or SQLXML
    ... I have a Microsoft SQL 2000 Server and I want to retrieve data from the ... server in XML format. ...
    (microsoft.public.sqlserver.xml)
  • BizTalk converts xsi:nil="true" to xsi:nil="1"
    ... I am using BizTalk 2006 r2 and MS SQL 2005. ... I have a stored procedure, ... which returns some data in xml format. ... Some of returned fields can be ...
    (microsoft.public.biztalk.general)
  • Turn value into element name, how?
    ... SQL so that I have results returned to me in XML format like this: ... <IwantToSpecifyThisParentTag-How?> ... Prev by Date: ...
    (microsoft.public.sqlserver.xml)
  • New ti xml database
    ... I need to use a file that is in xml format in vb.net. ... I have MSSql 2000 and vb.net 2003. ... I have accessed SQL ... Prev by Date: ...
    (microsoft.public.dotnet.xml)