扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
作者：佚名 来源：Yesky 2007年10月23日
关键字： SQL Server
在本页阅读全文(共3页)
| Select 1 as Tag, NULL as Parent, Orders.OrderId AS [Order!1!OrderId], Orders.OrderStatus AS [Order!1!OrderStatus], Orders.OrderDate AS [Order!1!OrderDate], Orders.SubTotal AS [Order!1!SubTotal], Orders.Tax AS [Order!1!Tax], Orders.ShippingHandling AS [Order!1!ShippingHandling], Orders.ShipToName AS [Order!1!ShipToName], Orders.ShipToAddressId AS [Order!1!ShipToAddressId], NULL AS [OrderDetail!2!OrderDetailId], NULL AS [OrderDetail!2!OrderId], NULL AS [OrderDetail!2!ItemId], NULL AS [OrderDetail!2!UnitPrice], NULL AS [OrderDetail!2!Quantity] from Orders UNION ALL |
/*订单详细信息是子 XML元素 */
| select 2 as tag, 1 as parent, Orders.OrderId AS [Order!1!OrderId], NULL AS [Order!1!OrderStatus], NULL AS [Order!1!OrderDate], NULL AS [Order!1!SubTotal], NULL AS [Order!1!Tax], NULL AS [Order!1!ShippingHandling], NULL AS [Order!1!ShipToName], NULL AS [Order!1!ShipToAddressId], OrderDetails.OrderDetailId AS [OrderDetail!2!OrderDetailId], OrderDetails.OrderId AS [OrderDetail!2!OrderId], OrderDetails.ItemId AS [OrderDetail!2!ItemId], OrderDetails.UnitPrice AS [OrderDetail!2!UnitPrice], OrderDetails.Quantity AS [OrderDetail!2!Quantity] from Orders, OrderDetails where Orders.OrderId = OrderDetails.OrderId ORDER BY [Order!1!OrderId],[OrderDetail!2!OrderDetailId] For XML EXPLICIT 写数据。 |
以下示例中，通过 HTTP请求提供表示层次行数据的 XML，然后将其传递到 ISAPI模板中指定的 Transact SQL代码。在存储过程中对 XML进行语法分析，并进行相应的写入操作：
| Create Procedure InsertOrder @Order NVARCHAR(4000) = NULL, @OrderId int Output DECLARE @hDoc INT DECLARE @PKId INT BEGIN TRANSACTION |
如果您非常迫切的想了解IT领域最新产品与技术信息，那么订阅至顶网技术邮件将是您的最佳途径之一。
京公网安备 11010802021500号