DeleteStudent (Stored Procedure)

CREATE PROCEDURE [dbo].[DeleteStudent]

                        @StudentId int

AS

BEGIN

BEGIN TRAN

DELETE FROM Students WHERE StudentId=@StudentId

COMMIT TRAN

END