Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. OPENQUERY can be referenced in the FROM clause of a query as if it were a table name.

When running a query on SQL Server that fetches columns through a linked MySQL server, MySQL fields of ENUM type have additional whitespace at the end if they are not the longest string in the enum. I ...

[LINKEDSERVER].TBRWeb.dbo.TeamMaster TM ON TS.TeamID = TM.TeamID WHERE Project = 1 ORDER BY StatsDate DESC, OverallRank ASC </pre><BR><BR>So, to answer your question, SQL Server seems to be smart ...

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.<BR><BR>Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...