sp_ww_newid

This is the NewId generation routine. This routine is fired by the business object and not by the database to allow for the business object to retrieve an id before the Database performs an insert.

Example

CREATE PROCEDURE sp_ww_NewID
  @cName char(30),
  @nRetval int OUTPUT
AS
UPDATE wws_Id 
  SET id = id + 1,
      @nRetval = id + 1
WHERE TableName = @cName