Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Error when selecting top N records from oracle Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 9:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 25, 2014 8:55 AM
Points: 16, Visits: 118
hi, I had similar problem a few years back... if im not mistaken, it all depended on the driver used to set up the linked server.
if used Microsoft driver (ODBC) then the top x works fine and if the driver was Oracle's then must use the rownum clause....

Post #1597345
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse