Xml dosyadan select çekme (Read an XML file from SQL Server)

DECLARE @idoc int

DECLARE @doc xml

DECLARE @TEMPSQL NVARCHAR(2000)

DECLARE @DOCPATH NVARCHAR(2000)

set @DOCPATH = ‘C:\param.xml’

SET @TEMPSQL = ‘SET @doc = (SELECT * FROM OPENROWSET(bulk ”’ +@DOCPATH + ”’,single_blob) as doc)’

EXEC SP_EXECUTESQL @TEMPSQL, N’@doc xml OUTPUT’,
@doc = @doc OUTPUT

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

SELECT * FROM OPENXML (@idoc,‘/ParametreBilgileri/OzelParametreler/PRGOZELPRM/Kayit_1′,2)
WITH (GRUPKOD varchar(20), ANAHTAR varchar(20)) WHERE GRUPKOD=‘BANKA’

EXEC sp_xml_removedocument @idoc