Article View: comp.database.ms-sqlserver
Article #1Re: Help: Need help creating a GetNextKey Stored Procedure
From: Jan den Ouden
Date: Sun, 01 Feb 1998 00:00
Date: Sun, 01 Feb 1998 00:00
33 lines
1761 bytes
1761 bytes
On Wed, 28 Jan 1998 10:49:12 -0500, Sean Chard <sean@recruiter.ca> wrote: >Hello. > >I am trying to create a stored procedure to get the next available >key from a specified table, so I can use it in my Delphi app. > >Here is the stored proc. as I have it so far: > >----------------------------------------------------- >CREATE PROCEDURE GetNextKey @Tablename Varchar(10) >AS > >Declare @sSQLStatement Varchar(255), > @CurKey Integer, > @NextKey Integer > >select @sSQLStatement = 'select @CurKey=max(prkey) from '+@Tablename >Exec (@sSQLStatement) > >select @NextKey = @Curkey + 1 >------------------------------------------- Did you consider using a generator? I usually use a generator in a stored procedure to generate unique key values. It works very simple and safe. Using the max function, may cause key violations when users simultaneously insert records, generators don't have that problem. E:mail denOuden@compuserve.com Wezep - Netherlands
Technical Details
Message-ID:
<34d4ca2a.20316091@news.compuserve.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<34CF5378.5F69@recruiter.ca>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10f695,d283056a621e56c3 X-Google-Attributes: gid10f695,public X-Google-Thread: f8191,d283056a621e56c3 X-Google-Attributes: gidf8191,public X-Google-Thread: 10de66,d283056a621e56c3 X-Google-Attributes: gid10de66,public X-Google-Thread: 11301e,d283056a621e56c3 X-Google-Attributes: gid11301e,public From: denOuden@compuserve.com (Jan den Ouden) Subject: Re: Help: Need help creating a GetNextKey Stored Procedure Date: 1998/02/01 Message-ID: <34d4ca2a.20316091@news.compuserve.com> X-Deja-AN: 321163665 References: <34CF5378.5F69@recruiter.ca> Newsgroups: comp.database.ms-sqlserver,microsoft.public.sqlserver.server,microsoft.public.sqlserver.programming,borland.public.delphi.database.sqlservers