DECLARE @XmlContent XML(SalesOrderStatuHistory)=(SELECT StatuHistory FROM SalesOrderStatu WHERE (SalesOrderID = @SalesOrderID));///获得数据库中的XML列数据
DECLARE @InsertContent xml ///定义要更新的XML数据
SET @InsertContent = '<Statu>
<EmployeeID>'+CONVERT(nvarchar,@EmployeeID)+'</EmployeeID>
<Statu>'+CONVERT(nvarchar,@Statu)+'</Statu>
<Cause>'+CONVERT(nvarchar(50),@Cause)+'</Cause>
<ModifiedDate>'+CONVERT(nvarchar,GETDATE(),120)+'</ModifiedDate>
</Statu>'; ///插入参数
SET @XmlContent.modify('insert sql:variable("@InsertContent") as last into (/Status)[1]'); ////实现参数化更新XML列
SELECT @XmlContent;