Can a procedure return a value?
I'll answer
Earn 20 gold coins for an accepted answer.20
Earn 20 gold coins for an accepted answer.
40more
40more
Works at the International Seabed Authority, Lives in Kingston, Jamaica.
You can execute the stored procedure with an output parameter without the OUTPUT keyword, but you won't be able to use the returned value in the calling program. ... RETURN also unconditionally exits the program, so once a RETURN is encountered in your T-SQL code SQL Server will not check any other conditions.
2023-05-08 12:30:23
评论(499)
Helpful(122)
Helpful
Helpful(2)

Lucas Sanchez
QuesHub.com delivers expert answers and knowledge to you.
You can execute the stored procedure with an output parameter without the OUTPUT keyword, but you won't be able to use the returned value in the calling program. ... RETURN also unconditionally exits the program, so once a RETURN is encountered in your T-SQL code SQL Server will not check any other conditions.