Re: ��ѯ�ʡ�DB2 ��һ��д�ڱ��е�sql��䣿

Article View: cn.bbs.comp.database

Article #1378

Back to cn.bbs.comp.database Previous Next

#1378

From: ���Ϲ�
Date: Sat, 25 Aug 2007 04:29

17 lines
1584 bytes

   ���û�мǴ�Ļ���Ӧ�ú�Oracleһ�������EXECUTE IMMEDIATE��ִ��

�� �� tec (Beautiful Protoss) �Ĵ������ᵽ: ��
: �����Ҷ�����һ������ temp 
: set temp = 'select * from test'; 
: ��SQL Server �п��� exec temp 
: ������DB2�£�����ô���أ� 
: ���ڳ�����
: ��PREPARE s1 FROM temp;EXECUTE IMMEDIATE s1;�� 
: ����
: (EXECUTE IMMEDIATE s1) 
: ������ѽ 
: ������ô����ѽ ��
: .................������ʡ�ԣ�
--

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

Technical Details

Message-ID: <4VcFlj$auc@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!panix!bloom-beacon.mit.edu!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,f51b71c7e086211b,start
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!panix!bloom-beacon.mit.edu!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS
From: tempdb.bbs@bbs.sjtu.edu.cn (������Ϲ�)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��ѯ�ʡ�DB2 �������һ��д�ڱ����е�sql��䣿 
Date: 25 Aug 2007 04:29:58 GMT
Organization: ��ˮ˼Դ
Message-ID: <4VcFlj$auc@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1188016125.A
Lines: 17

Article View: cn.bbs.comp.database

Re: ��ѯ�ʡ�DB2 �������һ��д�ڱ����е�sql��䣿

Re: ��ѯ�ʡ�DB2 ��һ��д�ڱ��е�sql��䣿