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
>

Query name change

I am using SQLServer 2000 with an Access 2003 .adp front end.
I created a view. And then I changed the name of the view.
In another SQLServer database (in the same server) using a different .adp
front-end, I imported the view (using File->Get External Data->Import).
After it was imported into the second database, it had the original name.
Any ideas on why this happened? Or how I can keep it from happening?
Thanks!
Jerrysp_rename doesn't change the name inside the source code for an object. You can try this yourself,
create a view, look in syscomments, rename it and then look again. You will have the old object name
in the stored source code.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JerryWendell" <JerryWendell@.discussions.microsoft.com> wrote in message
news:0DBB3987-AABB-4B13-A3BF-A357B09A3EB2@.microsoft.com...
>I am using SQLServer 2000 with an Access 2003 .adp front end.
> I created a view. And then I changed the name of the view.
> In another SQLServer database (in the same server) using a different .adp
> front-end, I imported the view (using File->Get External Data->Import).
> After it was imported into the second database, it had the original name.
> Any ideas on why this happened? Or how I can keep it from happening?
> Thanks!
> Jerry