devxlogo

Obtaining the Next Number in a Sequence Using a Stored Procedure and an Output Parameter

Obtaining the Next Number in a Sequence Using a Stored Procedure and an Output Parameter

There will be times when you need to get the next number in a sequence. Say, for example, you store all student numbers, or you keep track of them. Then, you need to get the next student number in the list and you do not know what it will be. With this stored procedure, you update the Settings table with a new number and return the number to whichever function executed the stored procedure:

CREATE PROC [dbo].[spGetNextNumber]@NextNumber INT OUTPUTASSET @NextNumber =    (      SELECT CurrentNumber FROM Settings WHERE ID = 1   )   UPDATE Settings SET CurrentNumber = @NextNumber + 1RETURN @NextNumber
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist