Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Tbl.Col.value('A','nvarchar(50)'),
- Tbl.Col.value('B','int'),
- Tbl.Col.value('C','nvarchar(50)'),
- Tbl.Col.value('D','nvarchar(1000)'),
- Tbl.Col.value('E','nvarchar(50)'),
- Tbl.Col.value('F','nvarchar(50)')
- FROM @xml.nodes('//row') Tbl(Col)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement