|
Posted by viriyur on 05/03/06 00:21
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 ?
Your help would be much appreciated.
Thanks
Navigation:
[Reply to this message]
|