Three kinds of methods for inserting XML data in SQL Server 2005

server|xml| Insert | Data we know that XML types are added to SQL Server 2005, which means that you can specify a column XML type when you create a table, such as:
CREATE TABLE Customers
(
Name VARCHAR not NULL PRIMARY KEY,
Description XML
)

So how do you insert data into columns of XML type?
There are basically three ways:
1. Use strings directly, such as
INSERT into Customers (FeedName, Feedxml) VALUES
(' Ramon Liu ', ' <description>rich customer</description> ')

2. Use for XML, such as
Go
--declare XML type variable
DECLARE @xmlDoc XML
SET @xmlDoc =
(
SELECT Name, SalesYTD from Sales.salesterritory
For XML AUTO, ROOT (' territories '), ELEMENTS
)
INSERT into Customers (name, description) VALUES
(' Stanley ', @xmlDoc)

3. Use OPENROWSET to load from a file, such as
Go
INSERT into Customers (name, description)
SELECT ' Justin ', xmlData from
(
SELECT * from OPENROWSET
(BULK ' D:\desc.xml ', Single_nclob)
As XmlData
) as feed (xmlData)
Go
SELECT * FROM Customers