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
Posted Tuesday, July 29, 2014 9:07 AM


Group: General Forum Members
Last Login: Friday, October 23, 2015 8:10 AM
Points: 16, Visits: 142
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