Article View: cn.bbs.comp.database
Article #426Re: ��̹���SQL����������ѯ
From: ��ϵ����*5������*shiyan��mm��
Date: Fri, 08 May 2009 11:14
Date: Fri, 08 May 2009 11:14
23 lines
1806 bytes
1806 bytes
лл��O(��_��)O~
�� �� 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 �Ĵ������ᵽ: ��
: .................������ʡ�ԣ�
--
[1;31mHebei
��������Զ��ů�ļ�
[0;1;5;36mqq����ϵ����[m
[1;33m��Ʒ����ӭ���� Tea ��
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.26.99][m
Technical Details
Message-ID:
<4fiNQf$bCl@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,8449b70fb603f391,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!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.cn99.com!news.shec6.edu.cn!SJTU From: qqlover.bbs@bbs.sjtu.edu.cn (��ϵ����*5������*shiyan��mm��) Newsgroups: cn.bbs.comp.database Subject: Re: ��̹���SQL����������ѯ Date: 08 May 2009 11:14:23 GMT Organization: ��ˮ˼Դ Message-ID: <4fiNQf$bCl@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1241781257.A