Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Get Next Seq Num (C#)
Title: Get Next Seq Num Language: C#
Description: Get the next sequence number for the given sequence name Views: 196
Author: Gareth Watt Date Added: 3/31/2008
Copy Code   
1    internal static int GetNextSeqNumber(String SequenceName)
2    {
3        String Sql;
4        Sql = "declare @sequence_id INT execute nextval '" + SequenceName + "', @sequence_id output Select @sequence_id as SequenceNumber";
5        return ExecuteSQl(Sql); 
6