Posted by Erland Sommarskog on 05/03/06 00:51

(viriyur@gmail.com) writes:
> I have a proc like this (T-SQL, SQL Server 2000):
>
> Alter Proc ImportXML
> @chvFullFileName varchar(200),
> @txtInputXML text=''
> AS
>
> My question is how can I load the contents of the XMLFile into the
> parameter called @txtInputXML ? Let us say my full file path is
> C:\XML\SampleXML.txt. I want to load this into parameter as one string
>
> What do I use ? bulkcopy or something else ?

From a client program read the file and then call the procedure.


--
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: Load XML souce file to a SP parameter
• Prev in forum: Re: How do I use pass data to/from stored procedure
• Thread view: Re: Load XML souce file to a SP parameter

[Reply to this message]