Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table dbo.tt(col1 xml)
- INSERT INTO dbo.tt(col1)
- SELECT *
- FROM OPENROWSET(BULK N'c:/tt/Test.xml', SINGLE_BLOB) AS col1
- select
- T.n.value('(./@v)[1]', 'varchar(50)')
- from dbo.tt tt
- cross apply tt.col1.nodes('
- declare namespace c="c";
- declare namespace a="a";
- declare namespace p="p";
- declare namespace t="t";
- declare namespace b="b";
- /c:Document//c:Table[.//p:Text/@v="Код профессионального стандарта"]//c:TableRow[.//p:Handle[@v="Sub"]]/c:TableCell[2]/c:TextPara[1]//p:Text') T(n)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement