Praveen Kumar

Praveen Kumar

  • 349
  • 6.5k
  • 2.1m

How to read repeated node value in SQL Server

Jun 18 2021 8:21 AM

How we can read all OrderId. I am using the following code to read but it is reading only first orderId

Sample Code

DECLARE @InputXMLHandle int
Declare @RequestXml xml = '
EXEC sp_xml_preparedocument @InputXMLHandle OUTPUT, @RequestXml
Select *
From OPENXML(@InputXMLHandle,'/Request/OrderStatus')
    OrderId varchar(50) 'OrderId'


Answers (1)