Article View: cn.bbs.comp.database
Article #193Re: SQL���
From: Dem����ɫ�н�����
Date: Sat, 25 Jul 2009 04:41
Date: Sat, 25 Jul 2009 04:41
24 lines
1220 bytes
1220 bytes
�����SQL Server 2005���ϰ汾�Ļ�������ʹ���Զ���ۺϺ���
SELECT [col1]
,dbo.strjoin([col2])
FROM [TestDB1].[dbo].[Table1]
group by col1
���巽���μ�����
�� �� zichuan (MSSQL�ǵ���רҵ�����) �Ĵ������ᵽ: ��
: col1 col2
: --------------------
: 1 a
: 1 b
: 2 c
: --------------------
: �����õķ����õ�
: 1 a,b
: 2 c
: ����cursor,лл
--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.145.142][m
Technical Details
Message-ID:
<4h9ADY$cGg@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTU From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����) Newsgroups: cn.bbs.comp.database Subject: Re: SQL��� Date: 25 Jul 2009 04:41:25 GMT Organization: ��ˮ˼Դ Message-ID: <4h9ADY$cGg@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1248496786.A