Ranjan’s Weblog

Query to Insert new record in table with generating new id in key column
If no records exist then new id is 1 else new id is greater then 1 of maximum id.

Example :

Inserting new product in product_master : -

Note : Assuming that productid is of type int.

Insert into product_master (productid,product_name,created_date)
select (select isnull(max(productid)+1,1) from product_master),’CPU’,getdate()