Answers for "how to use return value in stored procedure"

SQL
1

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
Posted by: Guest on November-12-2021

Code answers related to "how to use return value in stored procedure"

Code answers related to "SQL"

Browse Popular Code Answers by Language