CREATE PROCEDURE GETID @tbl char(10) AS set nocount on declare @TempId int UPDATE NumberTable SET @TempID = id_value, id_value = id_value + 1 WHERE tablename = @tbl SELECT @tempid