Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: From M$ to Linux and VB 6
> find out what's appending the ",col1.rowid " (which appears to be SS
> specific) and remove that piece of code.
I agree that the OP needs to figure out what is appending the extra column to the SELECT clause. That is the root of the problem.
But I do know that this is not SS specific. SS does not have the ROWID psuedo column as Oracle does. When I type the following query into one of my SQL Server instances:
select custid,rowid from compmon;
I get the following error:
Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'rowid'.
And prepending ROWID with the column name does not help either. For that, I get the following error:
Server: Msg 107, Level 16, State 2, Line 1 The column prefix 'custid' does not match with a table name or alias name used in the query.
This error leads me to believe that I would prepend with the table name instead, but that just leads back to the Msg 207 error.
Cheers,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Wed Jun 28 2006 - 19:04:40 CDT