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 vote375 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote352 views2 answers
Oracle create chain rule
SQL
3 votes372 views1 answer
Créer une table sql
SQL
0 vote549 views1 answer
Sql change a colum to unique
SQL
0 vote391 views1 answer
Sqlite get date only
SQL
7 votes335 views4 answers
How to reset the identity column in sql server
SQL
1 vote372 views2 answers
How to combine 2 tables in MySQL
SQL
2 votes355 views1 answer
Sql alchemy or
SQL
11 votes387 views4 answers
Update row in mysql
SQL
2 votes381 views2 answers
How to create an empty table from an existing table
SQL