Stored procedure return value

CREATE PROCEDURE GetDepartmentRecord 
AS 
DECLARE @DepartmentRow AS INT
SELECT @DepartmentRow=COUNT(*) FROM SampleDepartments 
RETURN @DepartmentRow
GO
DECLARE @return_value int
EXEC	@return_value = GetDepartmentRecord
SELECT	'Return Value' = @return_value
GO

Source: sqlshack.com

Similar codes

5 votes259 views2 answers
Mysql date greater than 30 days
SQL
0 vote170 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
15 votes160 views2 answers
Select where duplicate mysql
SQL
0 vote164 views1 answer
Install package for sqlserver in asp.net core
SQL
6 votes141 views5 answers
Get current date sql
SQL
0 vote177 views1 answer
Sql server create constraint
SQL
0 vote149 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
12 votes148 views4 answers
Mysql get date difference in hours
SQL
0 vote177 views2 answers
Unique key
SQL
20 votes172 views4 answers
Sql count if
SQL