query Oracle -> sqlserver

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

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

Re: query Oracle -> sqlserver

> 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]


wrote in message
news:1187085200.897757.223620@l70g2000hse.googlegroups.com.. .
> select pippo
> from
> (
> select person.name as pippo
> from person
> )
>
> This query run in oracle....in sqlserver no!
> what can i do!?
> thank's
>