why sp_ExecuteSql output parameter returns null from linked server when procedure shows correct value in results panel
0
votes
2
answers
261
views
I am trying to get SQL version from a linked server and save it in a variable, but the query runs fine and showed me the result but when I review the output variable is Null.
DECLARE @cmd NVARCHAR(MAX);
DECLARE @servername NVARCHAR(MAX);
DECLARE @result NVARCHAR(500);
SET @servername = 'SERVERNAME';
SET @cmd = 'SELECT * FROM OPENQUERY([' + @servername + '], ''SELECT @@VERSION'')';
EXEC sp_executesql @cmd, N'@queryresult NVARCHAR(500) OUT', @result OUT;
SELECT @result;
Asked by Carlos Zavala
(11 rep)
Apr 18, 2024, 08:03 PM
Last activity: Apr 21, 2024, 11:38 AM
Last activity: Apr 21, 2024, 11:38 AM