Answers for "allow a funciton to pass through a linkedserver open query in short form"

Whatever

0

allow a funciton to pass through a linkedserver open query in short form

DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @LinkedServer nvarchar(4000)SET @LinkedServer = 'MyLinkedServer'SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''SET @TSQL = 'SELECT au_lname, au_id FROM pubs..authors'')' EXEC (@OPENQUERY+@TSQL)

Posted by: Guest on July-15-2020

Source

Code answers related to "allow a funciton to pass through a linkedserver open query in short form"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#