You could also consider using two queries, one for determining the max(id) and the other for the insertion.


Another (crude) method is to use SQL Server's own version of autonumber. In the design view of the table, allow for increment and seed of 1.