简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

sqlserver 2008 xml 问题

WBOY
Release： 2016-06-07 15:39:44
Original
1331 people have browsed it

我的sqlserver2008无法定义XML数据类型，我想把一个xml（格式如下） xml row name="aaa" sex="man" age="16"/ row name="bbb" sex="woman" age="18"/ /xml 在数据库中解析成一个表（格式如下） name sex age --------------------------- aaaman 16 bbbwomn1

我的sqlserver2008无法定义XML数据类型，我想把一个xml（格式如下）

在数据库中解析成一个表（格式如下）

     name      sex      age

---------------------------

    aaa          man      16

    bbb         womn   18

请大家指导一下，谢谢！

Related labels：
sqlserver xml question
source：php.cn
Previous article：DataContext 连接SqlServer2008 出现40错误 Next article：对SQLServer中有主键的表tb,写出效率较高的翻到第二页的sql查询
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SQL Server: Using CASE WHEN expression with WHERE clause I have a new SpringBoot project with SQLServer and I need to replace the MySQL native quer...
From 2024-04-03 14:46:55
0
1
351
Unable to connect to SQL Server in Laravel I can't connect to sql-server in Laravel. I have given sqlserver configuration values ​​in...
From 2024-03-31 13:08:48
0
1
395
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！