Sample Header Ad - 728x90

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