Procedure add data in MS SQL

hi all,

can someone assist what am I doing wrong!..
I have two tables shop and shop_owner I want to have a procedure which will be adding shops to the mall(if owner open a new shop)


CREATE PROCEDURE  update_mall

AS
BEGIN
declare @man  varchar(30);
select * from shop_owner where owner_Id = 'MAN001' //assuming MAN001 is the ID admin enter in search box
set @man = 'MAN001'

if(@man= 'MAN001')
begin
insert into shop (owner_Id,shop_name,shop_location) values
('MAN001','Shine and smile','Kariakoo');
end
END

thanks

what you’re doing wrong is not telling us how you know that what you’re doing is wrong

what happens when you run that procedure? does it crash? return the wrong data? produce an error message?

lol!..I do not see the insert part working(if I select all in the shop table no data is added) though the query execute successful

thanks

Procedural language is the concluding part of sql oracle and it is very beneficial when storing a value into the database, moreover its secured and safe to keep it safe.

looks like english, sounds like english, but what the heck does it mean?