MSSQL SQL Server avoids the 0 error sharing method

Excerpt from:http://www.maomao365.com/?p=6612

Summary:
In SQL Server, SQL scripts are described below to avoid the sharing of methods with the exception of 0 errors

In the development of various business systems, there are usually zero-error errors, and two processing methods are shared below:
Method 1:case when End

Declare @a int ---MolecularDeclare @b int ---DenominatorSelect   Case   when @b=0  Then NULL Else @a/@b End   as [a divided by B]

Method 2:nullif
Nullif (expression A, expression B)
--Returns the expression a if the expression A is not equal to expression B
--Returns NULL instead

Declare @a int -- -Molecular Declare @b int -- -Denominator Select @a / Nullif (@b,0as[a divided by B]

MSSQL SQL Server avoids the 0 error sharing method