SQL(Query To Create AutoID)

Select isnull(Max(ID),0) + 1 as ID  from Table_Name