ELIMINATE DIVIDE BY ZERO By Jason S Printer Friendly Version

To Eliminate the divide by zero error in a calculation in SQL 2005.

To Eliminate the divide by zero error in a calculation in SQL 2005 use the following: DECLARE @a money, @b int SELECT @a=1, @b=0 SELECT     ISNULL(@a/NULLIF(@b,0),0)

Date operation ASP and SQL server 2005

Convert date in common format and compare in SQL 2005

Template Files (.TQL) in SQL Server to speed up documenation and for other benefits

Use IDENT_CURRENT to retrieve the last inserted value into the Identity column

SQL Server - Delete Records From All Tables

Article Discussion: ELIMINATE DIVIDE BY ZERO

Jason S posted at 18-Jun-08 01:54

Original Article