🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #122

Re: �����ʸ�����:��ô���ַ���ӵ���������ȥ?

#122
From: �F��ħ��ɳ
Date: Wed, 31 Mar 2010 10:32
23 lines
1922 bytes
declare @para varchar(30)
declare @name varchar(30)='xxx'
select @para = 'A'+@name+'a'
select @para
������Axxxa
������@name����30���ַ�û�취������@para�ij��Ȱ�
�� �� wisky (СϦ.5������.����һ��վ��ʱ.�) �Ĵ������ᵽ: ��
: ����@name����һ��cursor���ҵ���һ��varchar(30)
: declare @para varchar(30)
: ִ��select @para = 'A'+@name+'a'
: ��ֻ������Ǹ�'A'
: �Ӳ����Ǹ�'a'
: ������ô�����������Ǹ�'a'��
: лл
: ����һ��:������sql server��


--
��ͨ���\ħ����Ů����ɫ�ޥ����`���ѩ`��
����ޥ����`���ѩ`���� ħ�h���ե����ʥ륹�ѩ`����
ħ��ɳ ��������˽? �������ʡ�������Ρ���Ů������

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 61.152.248.27]
Technical Details
Message-ID: <4lBik2$aGa@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!nntp.club.cc.cmu.edu!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,afc837e00f13f9da,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4df683fd51,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!nntp.club.cc.cmu.edu!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU
From: Marisa.bbs@bbs.sjtu.edu.cn (�F��ħ��ɳ)
Newsgroups: cn.bbs.comp.database
Subject: Re: �����ʸ�����:��ô���ַ���ӵ���������ȥ?
Date: 31 Mar 2010 10:32:49 GMT
Organization: ��ˮ˼Դ
Message-ID: <4lBik2$aGa@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1270031522.A