| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: subselect in MS SQL Server
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C02C96.F712E0E0
Content-Type: text/plain;
charset="iso-8859-1"
I've worked with both Oracle and SQL Server. As long as you write your query in ANSI SQL-92 level 1 compliant format, you may use it against both databases.
Zhong
It's another beautiful day!
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Monday, October 02, 2000 10:26 AM
To: Multiple recipients of list ORACLE-L
Subject: subselect in MS SQL Server
We are doing migration from Oracle to MS SQL Server ( don;t ask why). Does anybody knows whether subselects could be used instead of columns in queries MS SQL Server?
Alex Hillman
------_=_NextPart_001_01C02C96.F712E0E0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>subselect in MS SQL Server</TITLE>
<META content="MSHTML 5.50.4207.2601" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=196432517-02102000><FONT face=Arial color=#0000ff size=2>I've
worked with both Oracle and SQL Server.</FONT></SPAN></DIV>
<DIV><SPAN class=196432517-02102000><FONT face=Arial color=#0000ff size=2>As
long as you write your query in ANSI SQL-92 level 1 compliant format, you may
use it against both databases.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><I><FONT face=Script>Zhong</FONT></I> <BR><FONT face="Comic Sans MS"
size=2>It's another beautiful day!</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Alex Hillman
[mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Monday, October 02, 2000
10:26 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
subselect in MS SQL Server<BR><BR></FONT></DIV>
<P><FONT face=Arial size=2>We are doing migration from Oracle to MS SQL Server
( don;t ask why). Does anybody knows whether subselects could be used instead
of columns in queries MS SQL Server?</FONT></P>
<P><FONT face=Arial size=2>Alex Hillman</FONT> </P></BLOCKQUOTE></BODY></HTML>
Received on Mon Oct 02 2000 - 12:34:06 CDT
 |
 |