How to Max Id Increment in sql

Jayakumars
Posted by Jayakumars under Sql Server category on | Points: 40 | Views : 867
hi

How to Max Id Increment in sql
============================

Create Proc sp_AutoIncr
as
Declare @Maxid int
set @Maxid=(Select CasT(max(ecode)AS int)as Id from Table_5)+1
Select @Maxid

Comments or Responses

Login to post response