dimanche 28 juin 2015

SQL Server 2012 Linked Server bug

When I run select from linked SQL Server 2012 like this:

select A.*
from A, (select TOP 1 * from B) as B
where A.test in (B.col1, B.col2)

I only get 1 row from A though A has many rows. B here is parameters table with only 1 row.

A and B here is synonyms which point to tables on remote server.

Aucun commentaire:

Enregistrer un commentaire