sir,

I Have a Problem in xml data importing Plese help me in this .
when i m insertning data through Application it is inserting but while I am using Store Procedure its giving the error

Running [dbo].[sp_xmlbulkinser t] ( @xmldata = D:\xml\rfid\Bra nches.xml, @table_name = Branches, @Action = xmlImport ).

The XML parse error 0xc00ce556 occurred on line number 1, near the XML text "D:\xml\rfid\Br anches.xml"....

DECLARE @results table (result xml)
DECLARE @xml XML
SELECT @xml =CONVERT(XML, bulkcolumn, 2)
FROM OPENROWSET(BULK 'D:\xmlfile\abc \Technicle10210 12.xml', SINGLE_BLOB)
AS x
select @xml



i want to stor this xml data in our sql database
so help me