Quick Solution to zero division errors in SQL Server Stored Procedures

Any division operation in SQLServer will result in a division error. Refer to the stored procedure: DC_ProjCost_SelByProjID.

Any division operation on SQL Server will encounter a division by zero error. Refer to the stored procedure: DC_ProjCost_SelByProjID.

Any division operation on SQL Server will encounter a division by zero error.

Refer to the stored procedure: DC_ProjCost_SelByProjID. (Note: This is my own search, so I will not put this UP here)

Copy the following prevention to the stored procedure to avoid this error.

-- The following two lines are used to crack the zero division error. It is prohibited to interrupt the zero Division Error and make it null.

SET ANSI_WARNINGS off

Set arithabort off

,