Hi ..
set Arithaboth and Ansi_Warnings as OFF to handle devide by Zero or any kind of arithmatic errors
happy coding....
set Arithaboth and Ansi_Warnings as OFF to handle devide by Zero or any kind of arithmatic errors
SET ARITHABORT OFF SET ANSI_WARNINGS OFF Declare @Denominator int =0 Declare @Numerator int =5 SELECT isnull(@Numerator / @Denominator,0) as Result
happy coding....
2 comments:
hi,
What this 2 line means...
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
@Angel : this two lines will help to ignore arithmetic error
Post a Comment