declare @country xml set @country =( select * from openrowset(bulk 'D:\TEMP\country_iso.xml',single_clob) as xmldata)insert XMLData (RawXml) values(@country )