This is how you create a stored procedure in SQL.
CREATE PROCEDURE update_new_insurance
@first_name varchar(50),
@last_name varchar(50),
@ins_assign Integer,
@db_id Integer
AS
UPDATE insurance_db
SET first_name = @first_name,
last_name = @last_name,
ins_assign...
Creating a stored proce...

