3>
4> CREATE TABLE dbo.ProductBilling
5> (ProductBillingID int IDENTITY(1,1) PRIMARY KEY,
6> ProductBillingXML XML NOT NULL)
7> GO
1>
2> INSERT dbo.ProductBilling(ProductBillingXML)
3> VALUES ('
4~
5~
6~
7~
8~ ')
9> GO
(1 rows affected)
1> INSERT dbo.ProductBilling
2> (ProductBillingXML)
3> VALUES ('
4~
5~
6~
7~ ')
8> GO
(1 rows affected)
1> INSERT dbo.ProductBilling
2> (ProductBillingXML)
3> VALUES ('
4~
5~
6~
7~
8~ ')
9> GO
(1 rows affected)
1>
2> set quoted_identifier on
3>
4> SELECT DISTINCT
5> ProductBillingXML.value
6> ('(/ProductBilling/OrderItems/Item/@name)[1]', 'varchar(30)') as BookTitles
7> FROM dbo.ProductBilling
8> UNION
9> SELECT DISTINCT
10> ProductBillingXML.value
11> ('(/ProductBilling/OrderItems/Item/@name)[2]', 'varchar(30)')
12> FROM dbo.ProductBilling
13> GO
BookTitles
------------------------------
NULL
Notes
SQL
SQL Notes
T-SQL
T-SQL Notes
(6 rows affected)
1>
2> set quoted_identifier off
3>
4> drop table dbo.ProductBilling
5> GO