SQL openquery puzzle

Question

question

Don 1 asked Jan 2, '10

SQL openquery puzzle

Select * From OpenQuery (Ftw003, 'Select * From Mold');

Returns one row from a table that has 12837 records

linked-server openquery

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-02T10:46:35Z

Rob Farley answered Jan 2, '10

Try using OPENROWSET instead. It could be something around the fact that OQ only returns one resultset, which could perhaps be getting confused depending on what your linked server is.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-02-13T15:05:20Z

Ian Roke answered Feb 13, '10

Something like this should hopefully do the trick?

SELECT *
FROM OPENROWSET(
    'SQLNCLI', 
    'Server=Ftw003;Trusted_Connection=yes;',
    'SELECT * FROM Mold'
);

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question