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

9 votes325 views2 answers
Current date in postgresql minus 1 day
SQL
5 votes181 views2 answers
Postgres update with if condition query
SQL
2 votes181 views1 answer
Postgresql create schema in specific database
SQL
1 vote174 views1 answer
Input in mysql
SQL
0 vote170 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote180 views1 answer
How to get one year old query from plan cache
SQL
0 vote170 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote231 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote192 views1 answer
How to create a table in sql stack overflow
SQL
0 vote163 views1 answer
SQL server select to get sum of hours
SQL