General information
Title:
Getting SQL Server stored proc return value
Hi,
Does anyone know how to get a return value from a SQL Server stored proc? For example, if I have a line of code "RETURN 123" in the proc, how do I receive that? The proc doesn't take an output parameter, just returns a number.
? SQLEXEC(nConnection,[exec MyProc]) && Returns a 1 showing that the call didn't have an error
Thanks.
Gary
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only