linked-server

相关标签：javascript jquery android 多少钱 iPhone

linked server db2 sql server '@' appearing in query results

I have开发者_运维知识库 setup a linked server from sql server to DB2. For some strange reason \'@\' is appearing in the result set from a query that performs where not exists between tables of sql ser[详细]

2023-02-18 02:43 分类：问答
SQL Server not running queries on remote (Linked MySQL) server

For various horrible reasons, we\'ve had to link SQL Server to a MySQL database using Linked Servers and an ODBC Data Source. The queries run fine, but looking at the query plans you can see that SQL[详细]

2023-02-17 02:22 分类：问答
"ORA-01747: invalid user.table.column, table.column, or column specification"

I am trying to execute this query against Oracle linked server, and getting the following error, which I know that my query is malformed, but I couldn\'t figure out where and how.[详细]

2023-02-16 15:34 分类：问答
How to run queries on multiple linked servers efficiently?

I have to run several queries on a set of linked servers.I want to try and do it without resorting to dynamic sql, but having trouble so far.[详细]

2023-02-16 14:46 分类：问答
SQL Server spatial and linked servers

I have a SQL Server instance that I\'ve added a linked server to another SQL instance. The table I\'m accessing on the linked server contains spatial types. When I try to que开发者_运维技巧ry the tabl[详细]

2023-02-16 13:43 分类：问答
How to find destination IP address of a linked server in SQL Server 2008?

How can I find the address of defined linked server in SQL Server开发者_如何学运维 2008? The link server is present and its connection test shows there is no problem. but I can not find where the link[详细]

2023-02-11 07:41 分类：问答
Selecting BLOB column from Oracle database to SQL Server database over linked server

How do I select a blob column from an Oracle database using OPENQUERY on a SQL Server that is using Linked Server to connect to the Oracle database?[详细]

2023-02-11 06:49 分类：问答
Slow INSERTs from SQL Server to MySQL Linked Server

We\'re doing a sort of roll-your-own replication from a SQL Server 2008 R2 database to a MySQL 5.1 database.This isn\'t true replication, as the MySQL box is acting as permanent storage and the SQL Se[详细]

2023-02-11 00:10 分类：问答
SQL Server 2008: insert into table in batches

I have a linked server (Sybase) set up in SQL Server from which I need to draw data. The Sybase server sits on the other side of the world, and connectivity is pretty shoddy. I would like to insert da[详细]

2023-02-08 02:04 分类：问答
how to setup an oracle 10 g linked server in sql server 2008 R2 (windows server 2008 R2) 64 bit

I need to setup a linked server on my new sql 2008 R2 server but there is no oracle data provider in providers list of my server and when I\'m trying to install oracle client or oracle data 开发者_高级[详细]

2023-02-07 15:29 分类：问答