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

16 votes133 views6 answers
Insert sql
SQL
4 votes130 views1 answer
Data types in sql
SQL
0 vote142 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote137 views1 answer
Difference between where and having clause
SQL
17 votes129 views6 answers
Change column name in sql
SQL
0 vote136 views1 answer
No suitable driver found for sqlite
SQL
0 vote129 views1 answer
Declare or use variable in snowflake
SQL
22 votes158 views1 answer
Mysql workbench
SQL
2 votes133 views3 answers
Sql delete duplicate
SQL
13 votes116 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL