4>
5>
6> CREATE TABLE dbo.ProductBilling
7> (ProductBillingID int IDENTITY(1,1) PRIMARY KEY,
8> ProductBillingXML XML NOT NULL)
9> GO
1>
2> INSERT dbo.ProductBilling(ProductBillingXML)
3> VALUES ('
4~
5~
6~
7~
8~ ')
9> GO
(1 rows affected)
1>
2> INSERT dbo.ProductBilling
3> (ProductBillingXML)
4> VALUES ('
5~
6~
7~
8~ ')
9> GO
(1 rows affected)
1>
2> INSERT dbo.ProductBilling
3> (ProductBillingXML)
4> VALUES ('
5~
6~
7~
8~
9~ ')
10>
11> GO
(1 rows affected)
1> set quoted_identifier on
2> SELECT ProductBillingXML.query('/ProductBilling/OrderItems/Item') from dbo.ProductBilling
3> GO
------------------------------------------------------------------------------------------------------------------------
----------------
(3 rows affected)
1>
2> set quoted_identifier off
3>
4> drop table dbo.ProductBilling
5> GO