sql - Significance of 1e8 in divisions -


I am trying to understand a small function call in SQL Server 2012. I tried to search it online but could not find much information.

The function is simple, its two values ​​are @value and @default, this function returns divx @default to both when @value is zero or 0, otherwise it will automatically be @ Returns the value.

This function is called in various SQL statements to avoid being divided by zero function. . 

  Select col1 / divfix (col2,1e8)

My question is, what 1e8 stands for here, and how to help overcome it Does divided by zero error?

means 10 ^ 8 (10 power 8), thus 100000000. This is a "power (10 , 8) "less for"

From a mathematical point of view, this "divide by 0" is not really a great way to handle IMHO.

Instead of using a small number (which makes some close to the calculus return '0), it is more understandable to use a few numbers (which give something close to infinity rather than a Nain / Failure But not at all ", as long as the last rounding is not equal to 0).


Comments

Post a Comment

Popular posts from this blog

graphviz - size of node with shape=circle -

I am trying to set the size of nodes in this way: Size = circle, width = .5, label = "controller", style = fill, fillcolor = "# 8EC13A"]; But all three nodes are in different sizes, how can I set a fixed size? From the DOT guide on page 4 it says the following: When drawn, the actual size of a node is the most requested size and the required area for its text label, unless the is fixed = true , then the width and height values ​​are applied. . In this way you need to add fixedsize = true to your code
Read more

android - TCP sending with Unity -

I am quite new to Unity, but I have created an app that sends a simple TCP message to the click of a button A very simple TCP server console application. This code works perfectly when I run it on my PC, but when I make it for Android and test through my phone the message does not reach the server. Am I doing it wrong? Is ordinary TCP interaction done differently with Android? Here is my Integration Code: Public Texture BTN Detection; Public GUIStyle style; TcpClient mySocket = New TcpClient (); Public Network Stream The Stream; Public string host = "my_ip_address"; Public Int32 port = 8888; Public sent Bull = false; Streamer; TheWriter; Streamer The Reader; Strange (ONGI) (if (GUI button (new rickety (screen. With / 2) - screen with / 4, (screen .4 / 2) - screen .4 / screen, with screen / 2, screen width / 2), BTN detection) {if (! Sent) {mySocket = new TcpClient (host, port); Thestream = mySocket.GetStream (); TheWriter = New Streamer (The Stream); TheReader = New St...
Read more

properties - C#: How to set default value for a property in a partial class? -

I am very new to C # so that please stand with me ... I apply I am doing a partial class, and like wanting to add two properties: public partial class SomeModel {public bool isSomething {get} Set; } Public listing & lt; String & gt; Get some listings { Set; } ... Additional methods for using the above Data Members ...} I would like to introduce both data members: IsSomething to True and SomeList to new list & lt; String & gt; () . Generally I will do it in the constructor, however, because it is a partial square, I do not want to touch the constructor (am I?). What is the best way to achieve this? Thanks PS I am working in ASP.NET MVC, adding functionality to some models, so partial orbit. updated for C # 6 The ability to assign a default value to C # 6 auto-properties added value can be any expression (it does not have to be a constant). Here are some examples: // string literally start with public string SomeProperty {get; Set;} = ...
Read more