Posted by Tony Rogerson on 08/14/07 10:50
> 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@hotmail.it> 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
>
Navigation:
[Reply to this message]
|