摘要:
DECLARE @XmlContent XML(SalesOrderStatuHistory)=(SELECT StatuHistory FROM SalesOrderStatu WHERE (SalesOrderID = @SalesOrderID));///获得数据库中的XML列数据 DECLARE @InsertContent xml ///定义要更新的XML数据 SET @InsertContent ='<Statu> <EmployeeID>'+CONVERT(nvarchar,@EmployeeID)+'</EmployeeID 阅读全文