Retrieving XML Data
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>
10> INSERT dbo.ProductBilling
11> (ProductBillingXML)
12> VALUES ('
13~
14~
15~
16~ ')
17>
18> INSERT dbo.ProductBilling
19> (ProductBillingXML)
20> VALUES ('
21~
22~
23~
24~
25~ ')
26>
27> select * from dbo.ProductBilling
28> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
ProductBillingID ProductBillingXML
---------------- -------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
---------------------------------
1 " name="SQL"/>
2 1" name="Notes"/>
3 " name="SQL Notes"/>
(3 rows affected)
1>
2> drop table dbo.ProductBilling
3> GO