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

Bineesh Viswanath
May 24 2016
Code

SELECT max(cast(column_name as int)) + 1
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:

SELECT max(cast(ProductID as int)) + 1
FROM PRODUCTS