How to avoid the “divide by zero” error in SQL?

by

In order to avoid a “Division by zero” error we have programmed it like this:

Select Case when divisor=0 then null
Else dividend / divisor
End ,,,

But here is a much nicer way of doing it:

Select dividend / NULLIF(divisor, 0) ...

Now the only problem is to remember the NullIf bit, if I use the “https://stackoverflow.com/” key.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. SET versus SELECT when assigning variables?
  4. Querying data by joining two tables in two database on different servers
  5. sql query to return differences between two tables
  6. Real life example, when to use OUTER / CROSS APPLY in SQL
  7. How to print VARCHAR(MAX) using Print Statement?
  8. Concatenate values based on ID
  9. Splitting delimited values in a SQL column into multiple rows
  10. How to find current transaction level?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. Restrict an SQL Server connection to a specific IP address
  13. Cumulative Total in MS Sql server [duplicate]
  14. How do I find the data directory for a SQL Server instance?
  15. sql server 2008 management studio not checking the syntax of my query
  16. Selecting COUNT(*) with DISTINCT
  17. SQL query to split column data into rows
  18. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  19. Transfer data from one database to another database
  20. How to connect to SQL Server from another computer?
  21. How to find third or nᵗʰ maximum salary from salary table?
  22. SQL “between” not inclusive
  23. Can I set ignore_dup_key on for a primary key?
  24. Using PIVOT in SQL Server 2008
  25. sql group by only rows which are in sequence
  26. How to find sum of multiple columns in a table in SQL Server 2005?
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. Query times out from web app but runs fine from management studio
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment