XML a tabla, Sql Server

XML a tabla

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 4, rows affected: 1, absolute service time: 0,17 sec

edit mode | history

  
Id
ContenidoXML

1
1
<Sheet1><Production_x0020_Line>L1B4</Production_x0020_Line><Item_x0020_Number>VPJG7F-10849-BD</Item_x0020_Number><Fecha>02/20 - 02/26</Fecha><cantidad>2</cantidad></Sheet1><Sheet1><Production_x0020_Line>L1B4</Production_x0020_Line><Item_x0020_Number>VPJG7F-10849-DD</Item_x0020_Number><Fecha>02/20 - 02/26</Fecha><cantidad>1</cantidad></Sheet1>


  
Production line
Item Number
Date
Quantity

1
L1B4
VPJG7F-10849-BD
02/20 - 02/26
2

2
L1B4
VPJG7F-10849-DD
02/20 - 02/26
1

λ

                                      .NET NoSQL database for rapid development