Handle Devide By Zero Error

Hi ..
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....

Comments

Angel said…
hi,
What this 2 line means...

SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
February 15, 2012 at 10:45 AM
Sandeep said…
@Angel : this two lines will help to ignore arithmetic error
February 15, 2012 at 11:06 AM
Post a Comment

Popular posts from this blog

Light-weight Popup using CSS and Javascript..

Image
Hello Friends Once Again with a Rocking point we have seen lots of Popup till now….. all are good at their places just search on Google “Model Popup” and you will get a long list of examples and javascripts for popup… Ajax Control toolkit Model Popup Extender http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/ModalPopup/ModalPopup.aspx   then few more   http://www.modalpopups.com/blog/ http://www.jquery-dev.com/2008/12/02/jqmodal-jquery-modal-popup-plugin one more javascript framework is Dojo http://www.dojotoolkit.org/ here i am also one type of popup… but i am sure you will like it because it don’t require any kind of configuration and dependencies…      it is combination of CSS and javascript… with 70:30 ratio…. means here CSS is used more and rest is javascript…. then also its more power full so from first sight you can determine its light–weight compare to other model popups here i have an example… 1: < input i...
Read more

Publish webservice locally without separate hosting

Image
Hi.. here is a way to deploy web service withing project... Here are the steps for it in your Project... right click on Project in Solution Explorer. Click on Add new Item and Select "Web Service" Name it as per required... and Click on "Add" Button... now you have your web service ready in local environment... put you code in Web Service .Cs file Build the Source and make sure its error free... now Deployment Part Right click on "References" in Solution Exporer, You will find.. three Options like     Add Reference     Add Web Reference     Add Service Reference Select "Add Web Reference", you will get a Pop up, in Below there are three links Browse to:     * Web services in this solution     * Web services on the local machine     * Browse UDDI Servers on the local network select "Web services on the local machine " You will get a list ...
Read more

Select Multiple Checkbox with Shift key in Gridview by javascript

Image
Hello Friends, Recently i was just looking at my Gridview where i have a checkbox in each row.. now i need to select all Check box.. for that lots of material is available on net.. and all are enough so i am not going to deep in it check out this… http://www.codeproject.com/KB/grid/GridCheckBox.aspx but now my problem was that i wanted to select few rows but not all let’s say in my gridview the number of records are around 100.. and i want to check the checkbox of first 35 records in that case i had to click on checkbox of all 35 rows. i thought, like all mail accounts like gmail, yahoo, live and in may more… i should be able to select multiple records by shift key. means select the first record and pressing shift key select the 35st record so all the records in between will be selected.. and for that i found lots of jquery or any other javascripts. but here i have tried to make something my own and i am happy to make it.. here is code on Page <asp:GridView ID=...
Read more