Questions about openquery
Read more about openquery
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Linked server SQL Server to Oracle not returning data
i have a stored procedure in SQL Server like this:
DECLARE @EFEKTIF_DATE VARCHAR(15);
SET @EFEKTIF_DATE = (SELECT REPLACE(CONVERT(NVARCHAR,CAST(GETDATE() AS DATE),106),' ','-') EFEKTIF_DATE)
DECLARE ...
Didit Praditya
Votes: 0
Answers: 1
Move Image column from OracleDB top SQL Server
I have access to an Oracle database and I need to bring its data into SQL Server. The table has a simple structure and I can't change anything on the Oracle side.
I created a linked server inside SQL ...
Pouya Kamyar
Votes: 0
Answers: 0
Query not returning same results local vs openquery
I have an Oracle database linked to a SQL Server database.
Whenever I perform a specific query in Oracle I get expected data.
The fields I'm selecting are
SELECT
J.JOBNUMBER AS JOBNUMBER,
J.OPENDATE...
Javier Eslava
Votes: 0
Answers: 2
How do you join OpenQuery onto another Select statement?
I have written statement using OpenQuery and now want to join it onto my another query, so that when I run the view it returns a table with records from both selects. How would I go about this?
These ...
Roguee1x
Votes: 0
Answers: 2