SQL Server Query to Get the Max +1 ID from a Table

  1. SELECT max(cast(column_name as int)) + 1   
  2. FROM table_name  
Lets look at the real time example:

I have a table named PRODUCTS. If want to get the Max +1 ProductID(PK) from this table, can use the following code:
  1. SELECT max(cast(ProductID as int)) + 1   
  2. FROM PRODUCTS