give me sample example of store procedure

CREATE PROCEDURE Insert
-- Add the parameters for the stored procedure here
	@Id  nvarchar(150),
	@Name nvarchar(150),
	@Addr nvarchar(500)
AS
BEGIN

        -- Insert statements for procedure here
    Insert Into Sample(Id,Name,Address) Values(@Id,@Name,@Assr )

    END
GO
--For Update
CREATE PROCEDURE Upadte
-- Add the parameters for the stored procedure here
	@Id  nvarchar(150),
	 @Name nvarchar(150),
    @Addr nvarchar(500) 

 AS
BEGIN

        -- Insert statements for procedure here
    Update sample set Name=@Name,Address=@Addr where Id=@Id

    END

CREATE PROCEDURE [dbo].[SPDoctor]
(
@DoctorName varchar(50),
@HospitalName varchar(50),
@ContactNo varchar(50)
)
	 
AS
BEGIN
 insert into tblDrug_Doctor(DoctorName,HospitalName,ContactNo)values(@DoctorName,@HospitalName,@ContactNo)

END

Create procedure product_List(@Class varchar(25))
as begin

select pm.part_name,pm.productID from product_master pm
where pm.product_classification like '%'+@Class

end