Openquery

coreman answered

Anyone use OPENQUERY() to call oracle 12c procs w/ SYS_REFCURSOR or dbms_sql.return_result()?

Dec 3, '19 openquery

DaveC edited

Using Distributed Queries

Jun 27, '18 sql-server-2008·excel·openquery·64-bit·jet

sriramya answered

DATE TIME conversion issue in linked server

Jun 6, '16 sql-server·linked-server·openquery·db2

Grant Fritchey answered

concatenate fields in openquery

Aug 31, '15 openquery

thesqlguyatl edited

Linked server query from Oracle DB is truncating aggregate function results.

Jul 9, '15 sql-server-2012·tsql·oracle·linked-server·openquery

Grant Fritchey converted comment to answer

Linked Tables inefficient?

Apr 30, '15 openquery·openrowset·linked

FlipTop answered

Query via linked server to DB2 gives different results

Mar 16, '15 datetime·openquery·sql 2012·db2

Mister Magoo commented

Passing parameter across Linked Servers

Oct 12, '14 openquery·int·cast

Tracking a scenario - Best practise method - OpenQuery and Index placement Closed

Sep 10, '14 sql-server-2008·indexing·insert·temporary-table·openquery

ThomasRushton edited

I want to do the comparision of temp table data with the linkedserver table data .Please help me how to write the query

Dec 27, '12 table·temporary-table·openquery

how to insert into temp table from openquery linked server table

Dec 27, '12 insert·temporary-table·openquery

Rashi asked

How to compare temp table field with linked server table field openquery

Dec 26, '12 openquery·temp

ThomasRushton edited

Export Sql Server ResultSet to Excel Sheet

Nov 19, '12 excel·export-data·openquery

dona answered

How to Use Open Query in a stored procedure on a linked server

Oct 26, '12 linked-server·openquery

Pavel Pawlowski commented

Issue - Openquery MDX

Jul 18, '12 openquery