elham deljooei

elham deljooei

  • NA
  • 84
  • 71.7k

try & catch

May 19 2013 7:05 AM


Hi friends



I've written  tow type
of code which do the same work, but I want to know  which one is better? 1 or 2? Why?



I mean about Try & Catch.



Please Help me.



1.     
 



ALTER Procedure [dbo].[Clerk_Insert]



 



@clk_Name                               nvarchar(80),



@clk_Family                             nvarchar(100),



@clk_FatherName                         nvarchar(80),



@clk_MeliCode                    char(10),



@clk_ShomarehShenasname          char(10),



@clk_PersonnelNumber             nvarchar(100)



 



As



Begin



Begin Try



Begin Tran a;



If exists(select clk_MeliCode, clk_Name, clk_Family, clk_FatherName, clk_PersonnelNumber
from Clerk



 where (clk_MeliCode = @clk_MeliCode)



 or (clk_Name= @clk_Name and clk_Family= @clk_Family and clk_FatherName = @clk_FatherName )or( clk_PersonnelNumber
=@clk_PersonnelNumber))



Begin



return -1;



End



else



begin



insert into Clerk



(clk_Name, clk_Family, clk_FatherName,clk_MeliCode, clk_ShomarehShenasname, clk_PersonnelNumber)



values



(@clk_Name, @clk_Family,@clk_FatherName,@clk_MeliCode,@clk_ShomarehShenasname, @clk_PersonnelNumber)



End



commit Tran a;



End Try



 



Begin Catch



Rollback Tran a;



select



ERROR_LINE() as
line, ERROR_MESSAGE() as messages;



End Catch



End



 



2.



ALTER Procedure [dbo].[Clerk_Insert]



 



@clk_Name                               nvarchar(80),



@clk_Family                             nvarchar(100),



@clk_FatherName                         nvarchar(80),



@clk_MeliCode                    char(10),



@clk_ShomarehShenasname          char(10),



@clk_PersonnelNumber             nvarchar(100)



 



As



Begin



If exists(select clk_MeliCode, clk_Name, clk_Family, clk_FatherName, clk_PersonnelNumber
from Clerk



 where (clk_MeliCode = @clk_MeliCode)



 or (clk_Name= @clk_Name and clk_Family= @clk_Family and clk_FatherName = @clk_FatherName )or( clk_PersonnelNumber
=@clk_PersonnelNumber))



Begin



return -1;



End



else



begin



insert into Clerk



(clk_Name, clk_Family, clk_FatherName,clk_MeliCode, clk_ShomarehShenasname, clk_PersonnelNumber)



values



(@clk_Name, @clk_Family,@clk_FatherName,@clk_MeliCode,@clk_ShomarehShenasname, @clk_PersonnelNumber)



End



End



Begin Try



Begin Tran a;



execute dbo.Clerk_Insert;



commit tran a;



End Try



Begin Catch



select



ERROR_NUMBER() as
Error_Numbers,



ERROR_LINE() as  Error_Lines,



ERROR_MESSAGE() as
Error_Messages;



rollback tran a;



End Catch;



go



 



 



 



 




Answers (4)