OPENQUERY is a T-SQL function that allows for executing a pass-through query on a linked server.
I need to write a procedure to collect data from several remote servers, I use linkedservers and OPENQUERY to gather …
sql tsql connection linked-server openqueryI'm writing a script that is supposed to run around a bunch of servers and select a bunch of data …
sql sql-server sql-server-2005 tsql openqueryI have a linked server Remoteserver containing a table that holds file and folder names from a dir When I …
sql-server openqueryI need to retrieve data from a linked server using a parameter, @PickedDate for example. The query works fine if …
sql-server dynamic-sql linked-server openqueryI have SQL Server 2012 full version installed on my standalone non-networked development PC running Windows 7 x-64. Let's say FOO is …
windows-authentication sql-server-2012 openrowset openquery sql-authenticationI'm trying to migrate a table from MySql to MSSQL using openquery but I keep getting the following error message: …
mysql sql sql-server odbc openqueryWe have an Oracle database that we access through OpenQuery for some stuff. You apparently can't do date comparisons directly …
sql-server oracle date openqueryI am trying to pull data from Mysql server using SQL server OPENQUERY function. When I run a query to …
mysql sql sql-server type-conversion openqueryI am trying to do a query via ODBC to our ERP database. The documentation guide suggests that we use …
sql-server odbc openqueryI'm having trouble using OPENQUERY (to fetch data from a linked server) within a stored procedure. I've been reading up …
sql-server-2005 stored-procedures openquery