在MSSQL中查询键值对数据库

-- 创建表格变量
DECLARE @KeyValueTable TABLE (
    [Key] NVARCHAR(50),
    [Value] NVARCHAR(50)
)

-- 插入键值对数据
INSERT INTO @KeyValueTable ([Key], [Value])
VALUES ('Key1', 'Value1'), ('Key2', 'Value2'), ('Key3', 'Value3')

-- 查询特定的键值对
SELECT [Key], [Value]
FROM @KeyValueTable
WHERE [Key] = 'Key1'

-- 创建XML变量并插入键值对数据
DECLARE @KeyValueXML XML = '
<KeyValuePairs>
    <KeyValuePair>
        <Key>Key1</Key>
        <Value>Value1</Value>
    </KeyValuePair>
    <KeyValuePair>
        <Key>Key2</Key>
        <Value>Value2</Value>
    </KeyValuePair>
    <KeyValuePair>
        <Key>Key3</Key>
        <Value>Value3</Value>
    </KeyValuePair>
</KeyValuePairs>'

-- 查询特定的键值对
SELECT KeyValue.value('(Key)[1]', 'NVARCHAR(50)') AS [Key],
       KeyValue.value('(Value)[1]', 'NVARCHAR(50)') AS [Value]
FROM @KeyValueXML.nodes('/KeyValuePairs/KeyValuePair') AS T(KeyValue)
WHERE KeyValue.value('(Key)[1]', 'NVARCHAR(50)') = 'Key1'