query Oracle -> sqlserver

#1

select pippo
from
(
select person.name as pippo
from person
)

This query run in oracle....in sqlserver no!
what can i do!?
thank's

#2

Quote:

select pippo
from
(
select person.name as pippo
from person
)

select pippo
from
(
select person.name as pippo
from person
) AS d

We force the use of AS and the alias clause.

Tony.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

<dario.8282 (AT) hotmail (DOT) it> wrote

Quote:

select pippo
from
(
select person.name as pippo
from person
)

This query run in oracle....in sqlserver no!
what can i do!?
thank's

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

query Oracle -> sqlserver

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

query Oracle -> sqlserver - 08-14-2007 , 04:53 AM

Re: query Oracle -> sqlserver - 08-14-2007 , 05:50 AM