how to pass xml file name as parameter to stored procedure

Question

User-1176759479 posted
hi,

i have created a stored procedure to read xml data


CREATE PROCEDURE InsertXML(@xml varchar(1000))
AS
DECLARE @XmlHandle int
EXEC sp_xml_preparedocument @XmlHandle output,@xml
insert into Employee(Name,ID,Sal,Address)
(SELECT Name,ID,Sal,Address
FROM  OPENXML (@XmlHandle, 'emp:EmployeeDetails/emp:Employee',2)
            WITH (Name varchar(30) 'Name',
                      ID int 'ID',
                      Sal int 'sal',
        Address varchar(30) 'Address'))
EXECUTE sp_xml_removedocument @XmlHandle


but it is taking only xml text as input.
but i want to send the file name as input.
how to do it.

Answer 1

User1416329745 posted

Try the thread below for two options using OpenXml in SQL Server 2000.  Hope this helps.

http://forums.asp.net/1118260/ShowPost.aspx

Answer 2

User221175343 posted

Hiii

May be These Links Will help you.

http://forums.asp.net/p/1428431/3192622.aspx

http://www.codeguru.com/csharp/csharp/cs_data/xml/article.php/c8151__3/Work-with-XML-Data-Type-in-SQL-Server-2005-from-ADONET-20.htm

http://msdn.microsoft.com/en-us/library/aa224820%28v=sql.80%29.aspx