Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > SQL Server中将多行的内容显示在一列中

SQL Server中将多行的内容显示在一列中

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 17:20:09
Original
1140 people have browsed it

SQL SERVER 2005支持XML格式数据，这个方法就是利用XML来进行转换。

SQL SERVER 2005支持XML格式数据，这个方法就是利用XML来进行转换。

STUFF(REPLACE(REPLACE((SELECT COL1 FROM [TABLE] N FOR XML AUTO ), '', ''), 1, 1, '')

在查询语句后加FOR XML AUTO可以得到查询结果的xml类型格式为:

通过replace函数替换掉xml中结果以外的数据。

通过stuff函数将第一个节点替换的,去掉。

linux

，
Related labels：
sql server
source：php.cn
Previous article：通过SSH通道来访问MySQL Next article：在Oracle 11gR2上使用RMAN实现整库迁移
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
Unable to connect to SQL Server in Laravel
From 1970-01-01 08:00:00
0
0
0
MacOS MAMP Pro supports Microsoft ODBC Driver 17 for SQL Server.
From 1970-01-01 08:00:00
0
0
0
I would like to ask all the teachers and seniors about cross-database join table query in TP5.1 ms sql server.
From 1970-01-01 08:00:00
0
0
0
Apache 2.4 URL rewriting: /server/?Server=ServerName to /server/ServerName
From 1970-01-01 08:00:00
0
0
0
tp5 can connect to the sql server database, but the data submitted by the form cannot be written to the database. What's going on?
From 1970-01-01 08:00:00
0
0
0
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