Is there a way to call a stored procedure with an input and output parameters?
I tried to run one but it gives me different errors depending on the order of the parameters. See below:
DECLARE @LinkedServer NVARCHAR(MAX)
EXEC spGetLinkedServerOpenQuery @DynamicSQL = N'SELECT * FROM sys.databases', @LinkedServer OUTPUT
SELECT @LinkedServer
/* Msg 119, Level 15, State 1, Line 56
Must pass parameter number 2 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'. */
DECLARE @LinkedServer NVARCHAR(MAX)
EXEC spGetLinkedServerOpenQuery @LinkedServer OUTPUT, @DynamicSQL = N'SELECT * FROM sys.databases'
SELECT @LinkedServer
/* Msg 8162, Level 16, State 2, Procedure spGetLinkedServerOpenQuery, Line 54
The formal parameter "@DynamicSQL" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output. */