How can I get the next value of the identity specification using SQL Server?
Select (id+1) from Table1
First of all, whatever you are doing, you are likely doing something wrong, because concurrency.
But you can get the next value of the identity column using
select ident_current('TableName') + ident_incr('TableName')