Stored procedure

Question

I have one input parameter categoryid.

I want to create a stored procedure for categoryfetch with this input parameter. I have a table category with columns categoryid, shopid, title, logicalcode.

Can any one tell the stored procedure for category fetch with one input parameter?

Answer 1

create procedure categoryfetch @categoryid int
as select shopid,title,logicalcode from category where categoryid=@categoryid end

for execute it

exec categoryfetch @categoryid=categoryid

Answer 2

create procedure categoryfetch 
    @categoryid int
as
    select categoryid, shopid, title, logicalcode 
    from category 
    where categoryid = @categoryid
go