All these solutions are stupid. Why not do this :
create PROCEDURE MY_TEST_PRO
(
@ID INT
)
AS
BEGIN
if (@ID > 10)
DELETE FROM Employee_Test WHERE Emp_ID=@ID
END
But, if you were trying to write pointless code to understand transactions then, yes, you don't commit after a rollback.