实验数据：

Create table  xmldata
(name NVARCHAR(20),
 age int,
 sex NVARCHAR(5)
)

INSERT INTO  xmldata VALUES (N'张三',12,N'男'),
(N'李四',12,N'女'),
(N'王五',12,N'男')

SELECT * FROM xmldata
Create table  xmldata
(name NVAR