sql server - Sql Transaction -

i new sql , wanted use rollback transaction in sql did this

--to insert instructor table--  create procedure [dbo].[insertinstructor] (@f_name varchar(50), @l_name varchar(50), @contact nvarchar(50)) begin     begin transaction      save transaction insert_instructor     insert instructor(f_name,l_name,contact)     values(@f_name,@l_name,@contact) end   --to rollback transaction did create procedure [dbo].[delete_instructor]   begin     begin transaction insert_instructor     rollback transaction insert_instructor   end 

i called these stored procedure in windows form application c#. tia

create procedure [dbo].[insertinstructor] (@f_name varchar(50), @l_name varchar(50), @contact nvarchar(50)) begin  begin transaction declare @flg_error  int      set @flg_error  = 0       insert instructor(f_name,l_name,contact)     values(@f_name,@l_name,@contact)      set @flg_error = @@error          if @flg_error <> 0 begin             raiserror ('1', 16, 1)             rollback transaction          end      commit transaction  end