USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_UpdateMedTech]    Script Date: 10/29/2020 12:30:26 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER  PROCEDURE [dbo].[Lab_UpdateMedTech]
@RequestNum as varchar(10),
@MedTechID as varchar(10),
@Pathologist as varchar(80) = '',
@PerformedId as varchar(10),
@DepartMent as varchar(100)


AS

update tbLabLogBook
set VerifyId = @MedTechID,
       Pathologist = @Pathologist,
	   MedtechId = @PerformedId,
	   DepartMent = @DepartMent
where RequestNum = @RequestNum;