openquery
Linked Server - LDAP - Msg 7321
Below is an abbreviated query I am trying to execute against LDAP using a linked server: select * from openquery(ADSI,\'\')[详细]
2023-04-12 18:04 分类:问答Openquery SQL how to check if exists?
I am using sql OPENQUERY to check if record exist passing parameter update it, if not insert a new record.[详细]
2023-04-08 18:16 分类:问答Open query in hibernate
I am using struts and hibernate in my problem. I tried the following query String hql =\"insert into\"+[详细]
2023-04-05 00:21 分类:问答Open query in hibernate exception
I am using struts2 and hibernate for development. The Java Code i used to run my open query is as follows[详细]
2023-04-04 08:23 分类:问答order hint for openquery?
I need to execute the following SQL (SQL Server 2008) in a scheduled job periodically. The Query plan shows 53% cost is sort after the data is pulled from the oracle server. However, I\'ve ordered the[详细]
2023-03-29 02:35 分类:问答Extremely slow insert OpenQuery performance on SQL Server to MySQL linked server
U开发者_运维百科sing SQL Server Management Studio to copy the entire contents of a table from SQL Server to an identical table on a MySQL machine. The MySQL db is connected to Management Studio as a l[详细]
2023-03-01 09:10 分类:问答SQL SP_EXECSQL @VAR to run a "dynamic" OpenQuery
I have an OpenQuery (Used in SQL2005 to run a query against a legacy database). I\'m building the string to run so that I\'ll return the last 6 months of data.[详细]
2023-02-05 06:51 分类:问答Possible to use "INSERT INTO @VARIABLE EXEC() AT LINKED_SERVER" syntax? (SQL Server 2005)
I am trying to execute a query on a linked server, but I need the results locally. DECLARE @test TABLE[详细]
2023-01-23 08:14 分类:问答Getting syntax error when trying to use OPENQUERY
I am trying to do a query via ODBC to our ERP database.The documentation guide suggests that we use OPENQUERY to send the query.[详细]
2023-01-18 15:47 分类:问答TSQL Openquery with Text Field hangs up MS SqlServer
This happens when I query a text field using linked server.For example: select * from op开发者_如何学Cenquery(LS,\'select text_field from table\')[详细]
2023-01-12 05:41 分类:问答