Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Sep 9, 2016

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 OUTPUT

AS

SET @NextNumber = 
   (
      SELECT CurrentNumber FROM Settings WHERE ID = 1
   )

   UPDATE Settings SET CurrentNumber = @NextNumber + 1

RETURN @NextNumber
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date