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
Hiç yorum yok:
Yorum Gönder