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

0 vote139 views1 answer
Mysql grouping functions
SQL
0 vote122 views1 answer
Report in database
SQL
6 votes120 views3 answers
Update with inner join postgres
SQL
1 vote131 views1 answer
Give a column name to values generated from case statement in sql
SQL
-1 vote127 views3 answers
Error mysql shutdown unexpectedly
SQL
25 votes138 views4 answers
Sqlserver add column
SQL
0 vote132 views1 answer
Declare or use variable in snowflake
SQL
0 vote122 views1 answer
Distinct data types in a table sql query
SQL
3 votes128 views2 answers
WhereIn SQL
SQL
4 votes124 views3 answers
Sql find second highest salary employee
SQL