How to call a SQLServer procedure in SQLMessenger?
I want to call a SQLServer procedure and get the query results. How should I set it up?
Yes, you can call procedures of SQLServer in SQLMessenger and retrieve query results from the procedures.
When calling a procedure, prepend the "exec" keyword to the procedure name in the statement. For example:
Notes:
(1) If you want to retrieve data from a procedure, add the statement “SET NOCOUNT ON;” in the procedure; otherwise, SQLMessenger cannot obtain the data queried by the procedure.
(2) If multiple datasets are returned in the procedure, SQLMessenger can only process one of them. Therefore, please try not to return multiple datasets in a single procedure.
(3) SQLMessenger does not support out-type parameters of procedures. It is impossible to obtain the return value of the procedure through out-type parameters.