Return Value - Stored Procedure

Return Value. Microsoft SQL Server Online Training For Beginners With Advance Concepts

Learn at Udemy

• Return value returns only integer value.
• Also it is not possible; to return more than one value using return value.

Create Procedure GetCustomersByCountryNameReturn
@CountryName varchar(50)
AS
Begin

The return will return the total customer’s count country wise.

END

Open a new query window.

Declare @TotalCount int

In order to get the return value

exec @TotalCount=GetCustomersByCountryNameReturn 'India'

Select @TotalCount