DECLARE @xmlData XML
SET @xmlData = (
SELECT * FROM OPENROWSET (
BULK 'D:\PROJECTS\AD Services\Source\AD Service_TLS\Services\TestSpecialSite\App.config', SINGLE_CLOB
) AS xmlData
)
DECLARE @hDoc AS INT
EXEC sp_xml_preparedocument @hDoc OUTPUT, @xmlData
SELECT [KEY], [Value]
FROM OPENXML(@hDoc, 'configuration/appSettings/add')
WITH
(
[KEY] varchar(100) '@key',
[Value] varchar(20) '@value'
)
WHERE [KEY] LIKE 'SpecialEmployer_%'
