If you need first <Order> element of your XML data you can use the next sentence. SELECT data.value('(ROOT/Customer/Order)[1]', 'varchar(100)') FROM test; ...
確定！ 回上一頁
