![]() ![]() The following example uses a pass-through INSERT query against the linked server created in example A. UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101')ī. The following example uses a pass-through UPDATE query against the linked server created in example A. The permissions that are used to connect to the remote server are obtained from the settings defined for the linked server. PermissionsĪny user can execute OPENQUERY. ![]() In particular, filter or join conditions applied on the result of one of those calls have no effect on the results of the other. For example: EXEC _msverĪny call to OPENDATASOURCE, OPENQUERY, or OPENROWSET in the FROM clause is evaluated separately and independently from any call to these functions used as the target of the update, even if identical arguments are supplied to the two calls. However, an extended stored procedure can be executed on a linked server by using a four-part name. OPENQUERY cannot be used to execute extended stored procedures on a linked server. OPENQUERY does not accept variables for its arguments. The maximum length of the string is 8 KB. ![]() Is the query string executed in the linked server. Is an identifier representing the name of the linked server. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 Comments
Leave a Reply. |