Valid 70-762 Dumps shared by ExamDiscuss.com for Helping Passing 70-762 Exam! ExamDiscuss.com now offer the newest 70-762 exam dumps, the ExamDiscuss.com 70-762 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-762 dumps with Test Engine here:
You have the following stored procedure that is called by other stored procedures and applications: You need to modify the stored procedure to meet the following requirements: Always return a value to the caller. Return 0 if @Status is NULL. Callers must be able to use @Status as a variable. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Explanation/Reference: Explanation: There are three ways of returning data from a procedure to a calling program: result sets, output parameters, and return codes. References: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/return-data-from- a-stored-procedure?view=sql-server-2017