[Sql server]2005的XML最佳实施策略(12)

declare @FK int

select @FK = PK from deleted

delete tblPropAuthor where propPK = @FK

更新触发器：在与更新的 XML 实例对应的属性表中删除现有行，并且在该属性表中插入新行

create trigger trg_docs_UPD

on T

for update

as

if update(xCol) or update(pk)

begin

declare @FK int

declare @wantedXML xml

select @FK = PK from deleted

delete tblPropAuthor where propPK = @FK

select @wantedXML = xCol from inserted

select @FK = pk from inserted

insert into tblPropAuthor

select * from dbo.udf_XML2Table(@FK, @wantedXML)

end

示例：查找作者的名字为"David"的 XML 实例

可以在 XML 列上表示该查询。另外，还可以在属性表中搜索名字"David"，然后与基表执行向后联接以返回 XML 实例，如下所示：

SELECT xCol

FROM T JOIN tblPropAuthor ON T.pk = tblPropAuthor.propPK

WHERE tblPropAuthor.propAuthor = 'David'