You don't have a view. You have a query and some statements.

a view is just like a table. You query it with a select.

A stored procedure is a set of statements, like you've listed at the bottom, that you enclose in the stored procedure structure. I'm not sure what you want to run or why you find this to be hard. If I want to run a

insert into tableB select x from tableB

in a stored procedure, I just put it in.

create procedure myproc

as

begin

insert into tableB select x from tableB

end