SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[proc_ActivateDeactivateUser]
(
@UserId varchar(50),
@IsActive bit,
@LastModifiedBy int
)
AS
BEGIN
Begin Try
IF(@IsActive = 1)
BEGIN
set @IsActive=0;
END
ELSE
BEGIN
set @IsActive=1;;
END
Update tbl_Users set IsActive=@IsActive,LastModifiedBy = @LastModifiedBy where UserId =@UserId
End Try
BEGIN CATCH
return '0';
END CATCH
END
No comments:
Post a Comment