469,643 Members | 2,061 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

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

Aug 14 '07 #1
1 1384
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]
<da********@hotmail.itwrote in message
news:11**********************@l70g2000hse.googlegr oups.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
Aug 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by vnl | last post: by
12 posts views Thread by Joe Stanton | last post: by
12 posts views Thread by zwasdl | last post: by
2 posts views Thread by Bob Alston | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.