【原创】XML数据库的操作-优快云博客

本文介绍在数据库中如何操作XML数据类型，包括创建包含XML字段的表、插入XML数据、更新XML内容以及查询XML数据等基本步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这篇主要介绍在数据库中如何对XML数据类型的操作，见代码，

XMLData OP
/* [Agent] is a Database name*/
USE [Agent]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Agent_Item]') AND type in (N'U'))
DROP TABLE [dbo].[Agent_Item]

USE [Agent]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Agent_Item](
    [ID] [bigint] NOT NULL,
    [ItemXMLData] [xml] NULL
) ON [PRIMARY]

INSERT INTO [Agent].[dbo].[Agent_Item]
           ([ID]
           ,[ItemXMLData])
     VALUES
           (1,null)
INSERT INTO [Agent].[dbo].[Agent_Item]
           ([ID]
           ,[ItemXMLData])
     VALUES
           (2,null)

UPDATE [Agent_Item]
   SET [ItemXMLData] =
   '<?xml version="1.0"?><Root>
    <Element Id="1" Att="False" />
    <Element Id="2" Att="True" />
    </Root>
   '

SELECT [ItemXMLData].query(' /Root/Element')
FROM [Agent_Item]

UPDATE [Agent_Item]
SET [ItemXMLData].modify('replace value of (/Root/Element/@Att)[1] with "True"')

SELECT [ItemXMLData].query('/Root/Element')
FROM [Agent_Item]

UPDATE [Agent_Item]
SET [ItemXMLData].modify('replace value of (/Root/Element/@Att)[2] with "True"')

SELECT [ItemXMLData].query('/Root/Element')
FROM [Agent_Item]

DELETE [Agent_Item]

转载于:https://www.cnblogs.com/OceanChen/archive/2009/03/31/1425959.html