Nov 29, 2019 12:59 AM|oned_gk|LINK
I guess you need to use insert into select command.
insert into tbl1 (a,b,c) select a+1,b,c from tbl1
or if you want include spesific id value
insert into tbl1 (a,b,c) select @param1,b,c from tbl1
you can use scope_identity() to get the new id