SQL openquery puzzle

Question

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

Returns one row from a table that has 12837 records

Answer 1

0

Something like this should hopefully do the trick?

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

answered Feb 13 '10 at 03:05 PM

Ian Roke
1.7k ● 24 ● 29 ● 31

(comments are locked)

Answer 2

0

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.

answered Jan 02 '10 at 10:46 AM

Rob Farley
5.7k ● 13 ● 17 ● 19

(comments are locked)

SQL openquery puzzle

Follow this question

Related Questions