create proc IDNew
as
begin
declare @IdNew int
set @IdNew=(select max(TableName.ID) from TableName
Insert Into TableName(ID) values @IdNew
end
go
--------------------------------
create proc client
@IdNew int output
as
select @IdNew=max(ID) From TableName