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

Article View: cn.bbs.comp.database

Article #432

Back to cn.bbs.comp.database Previous Next

#432

From: Galaxy��VOLUNTEERS��Database
Date: Mon, 11 May 2009 10:48

30 lines
1945 bytes

�ؼ����ⲻ������ʲô����,�����ڶ������...

���Ҫ��������Ϊ����,��Ҫʹ�ñ����:
declare @i table(a int)
insert @i values(1)
insert @i values(2)

SELECT [id]
      ,[datetime]
  FROM [TestDB1].[dbo].[DateTable]
  where id in (select a from @i)
GO

�� �� xiyuewang (����ѩ���Ұ�����) �Ĵ������ᵽ: ��
: �����Ǵ洢��̵���Ҫ����
: select * from [Herarchy], [product_list]
:   where [product_list].[subclass_name]=[Herarchy].[subclass_name]
:   and [product_list].[IS_No] in (@IS_NoSet)
: ����@IS_NoSet��һ���ַ���1. @IS_NoSet='A123'; 2. @IS_NoSet='A123','B123'.
: �ڵ�һ������¿������У����ǵڶ��־ͳ����ˡ�
: ��������������ʵ��ͬ��Ĺ���Ҳ�С�
: ��ѧSQL����Ұ��æ������


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

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

Technical Details

Message-ID: <4fkdFi$b0c@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news2.arglkargh.de!zen.net.uk!dedekind.zen.co.uk!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 4df683fd51,5ad6e2405c8e9307,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news2.arglkargh.de!zen.net.uk!dedekind.zen.co.uk!news.isoc.lu!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���MSSQL�д洢��̵�һ�����⡣
Date: 11 May 2009 10:48:50 GMT
Organization: ��ˮ˼Դ
Message-ID: <4fkdFi$b0c@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1242038780.A

Article View: cn.bbs.comp.database

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

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