how to read an xml file on local file system - 05-23-2005 , 03:57 AM
i have a xml file c:\abcd.xml in my local filesystem.. i just want to
take the path as in parameter for a stored procedure and insert the values
into a table type variable
execute usp_xx (@xmlpath='c:\abcd.xml')
-- inside the sp i would like to read the xml file and insert the same
into a table type variable..
Can anyone tell me the idea..
Message posted via http://www.sqlmonster.com
Re: how to read an xml file on local file system - 05-24-2005 , 02:05 AM
You should read the file on the mid-tier/client and send the data as a
stored proc parameter value in SQL Server 2000. SQL Server 2005 will have a
way to read from files...
"narasimha rao chandramouli via SQLMonster.com"
<forum (AT) nospam (DOT) SQLMonster.com> wrote