Openrow set and dynamic query

DECLARE @xmlDoc XML , @XMLFileName VARCHAR(500)


DECLARE @FileName Varchar(256) = 'Stud.xml'
SET @XMLFileName='D:\XMLSamples\'+@FileName


--SET @xmlDoc =(sELECT  CONVERT(xml, BulkColumn, 2)
--              FROM OPENROWSET (BULK 'D:\XMLSamples\Stud.xml', SINGLE_BLOB)    AS xmlData   )


EXEC('SELECT  CONVERT(xml, BulkColumn, 2) XMLdata INTO ##temp
              FROM OPENROWSET (BULK  '''+@XMLFileName+''', SINGLE_BLOB)    AS xmlData'  ) 

SELECT * FROM ##temp

---

sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.