1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
| USE [Seica-Takaya]
GO
*
*
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
*
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML
*
*
SELECT @XML = XMLData FROM XMLwithOpenXML
*
*
SELECT Judge,DTotal,Total ,MName ,DateOfTest ,TimeOfTest ,TestTime,MVersion ,TesterID ,MIndex ,MMessage FROM OPENXML(@hDoc, 'Faildata/Header')
WITH (
Judge [nvarchar](10) '@Judge',
DTotal [float] 'DTotal',
Total [float] 'Total',
MName [nvarchar](255) 'MName',
DateOfTest [datetime] 'DateOfTest',
TimeOfTest [time] 'TimeOfTest',
TestTime [time] 'TestTime',
MVersion [nvarchar](10) 'MVersion',
TesterID [nvarchar](255) 'TesterID',
MIndex [nvarchar](255) 'MIndex',
MMessage [nvarchar](255) 'MMessage')
*
SELECT GroupID ,Step ,Aux ,Parts ,Val ,Comment ,Loc ,Func ,PTolUnit ,MTolUnit ,MMode ,MRange,MTime ,RefEL ,RefValUnit ,RefFigUnit ,TestEL ,TestVal ,TestFig ,AccessProbe ,Pin ,Contact ,DPass ,DFail ,TPass ,TFail FROM OPENXML(@hDoc, 'Faildata/ABSIDE/Group/Step/T.Info')
WITH (
GroupID [int] 'GroupID',
Step [nvarchar](255) 'Step',
Aux [varchar](10) 'Aux',
Parts [nvarchar](10) 'Parts',
Val [nvarchar](10) 'Val',
Comment [nvarchar](255) 'Comment',
Loc [nvarchar](10) 'Loc',
Func [nvarchar](10) 'Func',
PTolUnit [float] 'PTolUnit',
MTolUnit [float] 'MTolUnit',
MMode [nvarchar](255) 'MMode',
MRange [int] 'MRange',
MTime [float] 'MTime',
RefEL [varchar](10) 'RefEL',
RefValUnit [float] 'RefValUnit',
RefFigUnit [float] 'RefFigUnit',
TestEL [varchar](10) 'TestEL',
TestVal [float] 'TestVal',
TestFig [float] 'TestFig',
AccessProbe [varchar](255) 'AccessProbe',
Pin [float] 'Pin',
Contact [float] 'Contact',
DPass [float] 'DPass',
DFail [float] 'DFail',
TPass [float] 'TPass',
TFail [float] 'TFail'
)
*
*
EXEC sp_xml_removedocument @hDoc
GO |
Help XML - SQL
Répondre avec citation
Partager