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 = @ins_assign,
WHERE (db_id = @db_id)
RETURN