Can i return SQL procedure before committing the transaction?

Viewed 5005

Can i use return statement in a sql transaction procedure?

Sql Procedure

ALTER PROCEDURE [dbo].[uspProcessStudentRecord] 
AS 
Begin Transaction
insert into dbo.Student(name,address) values('ABC','INDIA'); 
return; 
Commit Transaction 

Is it a good practice of writing return inside a Transaction?

3 Answers
Related