Exam 70-762 topic 1 question 100 discussion

I think is BD

The answer is C and it contains 2 actions - replace Null value with 0 and add an output parameter and it *doesn't* need RETURN statement. All the rest will not work because the rest option either don't replace NULL with 0 or they don't return value to the caller.

The correct answer is C and D, you need to return @Status variable to the caller as the problem states. Using "Return Code" will return an integer type value to the caller which is not needed in this context

I think the answer is correct . Needed two statements 1) output parameter and 2) return statement. CREATE PROCEDURE Sales.uspGetEmployeeSalesYTD @SalesPerson nvarchar(50), @SalesYTD money OUTPUT AS SET NOCOUNT ON; SELECT @SalesYTD = ISnull(SalesYTD ,0) FROM Sales.SalesPerson AS sp JOIN HumanResources.vEmployee AS e ON e.BusinessEntityID = sp.BusinessEntityID WHERE LastName = @SalesPerson; RETURN

BG: It does not say @Status should be set to 0 if it is null. It only states that it needs to return 0 which is the default value for a successful stored procedure's return statement.

I think CD will be answer. You can return results using result set by using select statement and then by using output parameter

1. Returning Data Using Result Sets If you include a SELECT statement in the body of a stored procedure (but not a SELECT ... INTO or INSERT ... SELECT), the rows specified by the SELECT statement will be sent directly to the client. 2.Returning Data Using an Output Parameter If you specify the OUTPUT keyword for a parameter in the procedure definition, the procedure can return the current value of the parameter to the calling program when the procedure exits. 3. Returning Data Using a Return Code A procedure can return an integer value called a return code to indicate the execution status of a procedure. You specify the return code for a procedure using the RETURN statement.