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

11 votes178 views2 answers
Oracle all source
SQL
33 votes197 views6 answers
Change column name in mysql
SQL
2 votes190 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote195 views1 answer
Create table in dbms cmds
SQL
11 votes223 views1 answer
Ddl view
SQL
0 vote182 views1 answer
Replace multiple string in query sql
SQL
0 vote195 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote198 views1 answer
Initcap in mysql
SQL
5 votes208 views1 answer
Oracle list packages
SQL
0 vote194 views1 answer
How to avoid duplicate records in sqlite
SQL