Re: ��̹��SQL��ѯ

Article View: cn.bbs.comp.database

Article #425

Back to cn.bbs.comp.database Previous Next

#425

From: Galaxy��VOLUNTEERS��Database
Date: Fri, 08 May 2009 06:52

21 lines
1621 bytes

��,��������������ÿ���ʻ���Ȩ��Ҳ�Ƿǳ���Ҫ��
�ⷽ��SQL Server�а�Ƥ��ο�
�� �� zichuan (����) �Ĵ������ᵽ: ��
: �ַ����ӣ� exec('select * from '+@table)
: ����: EXECUTE sp_executesql 
:           N'SELECT * FROM AdventureWorks.HumanResources.Employee 
:           WHERE ManagerID = @level',
:           N'@level tinyint',
:           @level = 109;
: ������������������������������������
: ����һ�ַ�ʽ��@table = 'table; drop table'����ô������ƻ������ڶ��ֱ�������
: ����
: �� �� qqlover �Ĵ������ᵽ: ��
: .................������ʡ�ԣ�

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

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

Technical Details

Message-ID: <4fiGYA$bKh@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.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!news3.google.com!feeder.news-service.com!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: ��̹���SQL����������ѯ
Date: 08 May 2009 06:52:35 GMT
Organization: ��ˮ˼Դ
Message-ID: <4fiGYA$bKh@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1241765482.A

Article View: cn.bbs.comp.database

Re: ��̹���SQL����������ѯ

Re: ��̹��SQL��ѯ