Posted by Erland Sommarskog on 05/03/06 10:31

(viriyur@gmail.com) writes:
> Thanks for the reply. Understand your point.
> But do not want to use a client program or VB.
> Is there a way I can load the file directly from SQL ?

You could use BULK INSERT to load the file into a table. But then you will
not be able to get the XML document out of the table and into a variable,
because you cannot assign to text variables. (If the document is small
you can use nvarchar(4000) or varchar(8000).)

Depending on what you want to do, a better bet may be the XML bulk load
that comes with SQLXML 3.0, which is freely downloadable from Microsoft.
I have never used it myself, so I cannot assist with it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How do I use pass data to/from stored procedure
• Prev in forum: Re: Raising errors in a catch block in SQL2005
• Thread view: Re: Load XML souce file to a SP parameter

[Reply to this message]