Top "Openquery" questions

SQL Linked Server Update Openquery syntax error

I am trying to update data in a PervasiveSQL backend (Sage ERP system) from SQL Server 2008 R2 via a Linked …

sql-server-2008-r2 openquery pervasive

How to pass datetime as parameter to a sql openquery

I have an OPENQUERY statement SELECT * FROM OPENQUERY (NETLINE, 'SELECT * FROM XCREW.CTNAISV_HOTELCREW where RESERVATION_DATE = ''2015-05-01…

sql sql-server database openquery

DELETE FROM Openquery

I'm doing a project at work regarding linked servers. As we need to pass the name of the linked server …

sql openquery

Convert text blob to nvarchar from Firebird to SQL Server

I am using SQL Server and have got a Firebird database as a linked server in my SQL Server. I …

sql sql-server type-conversion firebird openquery

Insert into table on the Linked Server with data from local table

I'm working with SQL Server Express, I created a linked server to an Oracle database. As the title indicates, I …

sql-server oracle tsql linked-server openquery

How to optimize simple linked server select query?

I have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15) on a MSSQL …

sql-server tsql performance linked-server openquery