Monday, March 12, 2012

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'sselect pippo

Quote:

Originally Posted by

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.itwrote in message
news:1187085200.897757.223620@.l70g2000hse.googlegr oups.com...

Quote:

Originally Posted by

select pippo
from
(
select person.name as pippo
from person
)
>
This query run in oracle...in sqlserver no!
what can i do!?
thank's
>

No comments:

Post a Comment