-----Oracle ��SQL Server��Ķ�Ӧ�Ƚϣ��

Article View: cn.bbs.comp.database

Article #8679

Back to cn.bbs.comp.database Previous Next

#8679

From: Abigail
Date: Thu, 06 Nov 2003 07:19

24 lines
1721 bytes

����˭���ⷽ����飬������
���Ƽ����򷢸�������
��Ϊ������Ҫ����Oralce�Ѿ���ִ�е�SQL���ת������SQL Server��ִ�С�
��Щ�ǲ���Ҫ�仯����Щ�����е㲻ͬ�ġ�
˳�������һ��������Oracle��ִ�еģ�������SQL Server�ϸ�����
select scrno,
       scrname,
       scrdesc,
       scrtype,
       shortcut,
       screen.locked,
       modby,
       '            ' as empname,
         0 as empno,
       modtime,
         module.modno,
         module.modname,
         module.moddesc
from screen,module
where screen.modno = module.modno(+)
����������� ��������ʾʲô��˼��
лл��
--
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.25.55][m

Technical Details

Message-ID: <49A2HO$bGk@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,9c0a3b2f5e645614,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-05 23:16:28 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.ccie.net.cn!SJTU
From: Abigail.bbs@bbs.sjtu.edu.cn (Abigail)
Newsgroups: cn.bbs.comp.database
Subject: -----Oracle ������SQL Server����Ķ�Ӧ�Ƚϣ���
Date: 06 Nov 2003 07:19:08 GMT
Organization: ��ˮ˼Դ
Message-ID: <49A2HO$bGk@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1068102984.A

Article View: cn.bbs.comp.database

-----Oracle ������SQL Server����Ķ�Ӧ�Ƚϣ���

-----Oracle ��SQL Server��Ķ�Ӧ�Ƚϣ��