Top "Openquery" questions

OPENQUERY is a T-SQL function that allows for executing a pass-through query on a linked server.

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 …

Read More
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…

Read More
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 …

Read More
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 …

Read More
sql sql-server type-conversion firebird openquery