Divide by zero error encountered in SQL Server

-

       Msg 8134, Level 16, State 1, Line 1
      Divide by zero error encountered.



        select col1/col2 from tbl
        select 12/0


                        if col2 field value as Zero then You get    Divide by zero error encountered. Error on Your SP.
  You Can USE NULLIF  SQL Function to Solve this Problem.

           select col1/ NULLIF(col2,0)

Comments

Post a Comment

Thank You for your Comment

Popular posts from this blog

Display Canvasjs Line Chart using Data from Database

-
Image
Aspx Page: <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Canvasjs.aspx.cs" Inherits ="BloggerCont.Canvasjs" %> < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < script src ="jquery-1.7.1.js" type ="text/javascript"></ script >     < script src ="canvasjs.min.js" type ="text/javascript"></ script >     < script type ="text/javascript">         $(document).ready( function () {             Disp();         });         function Disp() {             var dataPts = [];             var var1;         ...
Read more

Insecure cookie setting: missing Secure flag

-
  Issue Description: Insecure Cookie Setting - Missing Secure Flag Explanation: The "Secure" flag is an attribute that can be set for cookies in web applications. When the Secure flag is enabled for a cookie, the cookie is only transmitted over HTTPS connections, ensuring that it is sent securely over an encrypted channel. This is crucial for security because it helps prevent the exposure of sensitive information contained in cookies, such as session tokens or authentication credentials, to potential attackers. When the Secure flag is missing from a cookie, it means that the cookie can be sent over both secure (HTTPS) and non-secure (HTTP) connections. This can pose a significant security risk, as sensitive information could be exposed if the cookie is transmitted over an insecure connection. Impact: The impact of missing the Secure flag on a cookie depends on the context in which the cookie is used. Here are some potential risks: Session Hijacking: If an attacker can inter...
Read more

Tips for Protecting Your Email Privacy

-
Image
                                 Sending an email message is certainly more private than  posting on a social networking site, but email has its own dangers. Here are six tips to help you  communicate   without risking your privacy. The protection of  email  from unauthorized access and inspection is known as  electronic privacy . In countries with a constitutional guarantee of the  secrecy of correspondence , email is equated with  letters  and thus legally protected from all forms of  eavesdropping . 1.Use a Strong Password You  give  out  your  email  address  all  the  time;  it’s  not  really  private  information.  That  being  the  case,  the  only  thing protecting your account  from misuse is the password.  A malefactor who ...
Read more