SQL stored procedure to delete a specific record based on id

USE [DB_Name]
 GO
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 ALTER PROCEDURE [dbo].[sp_DeleteMember]
 @Id as bigint
 AS
 BEGIN
     SET NOCOUNT ON;
Delete from Members_Table where  ID = @Id
END