Re: ��MSSQL�д洢��̵�һ��⡣

Article View: cn.bbs.comp.database

Article #434

Back to cn.bbs.comp.database Previous Next

#434

From: Dem��ɫ�н��
Date: Tue, 12 May 2009 04:47

17 lines
1228 bytes

�ö�̬ƴ����䰢...��ȷҲ���ַ���...
�� �� zichuan (MSSQL�ǵ���רҵ�����) �Ĵ������ᵽ: ��
: declare @str varchar(100)
: set @str = '1,2,3'
: exec('select * from test1
: where id in ('+ @str + ')')
: �Ƽ�ʹ�� sp_executesql 
: �� �� Dem �Ĵ������ᵽ: ��
: : ������...
: : ֻ��ʹ�ñ�������Լ��ô�����ַ�
: : Ӧ�ó���ͻ������������


--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg

[m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 124.79.145.227][m

Technical Details

Message-ID: <4flJMA$ame@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU
From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���MSSQL�д洢��̵�һ�����⡣
Date: 12 May 2009 04:47:00 GMT
Organization: ��ˮ˼Դ
Message-ID: <4flJMA$ame@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1242103594.A

Article View: cn.bbs.comp.database

Re: ���MSSQL�д洢��̵�һ�����⡣

Re: ��MSSQL�д洢��̵�һ��⡣