Create a store procedure and use this code to insert .it insert prod_id automatically
<pre lang="SQL">
create procedure sp_insert_products
declare @prod_id nvarchar
as
set @prod_id = ( select isnull( (max(cast( prod_id as int ))),0) + 1 from products )
begin
insert into tbl_products
values (your values goes here)
end