skip to main
|
skip to sidebar
sqlpractice
Tuesday, June 9, 2009
Solution to SQL Server Error "Divide by zero error encountered"
DECLARE @input int
SET @input = 25*5
SELECT (CASE @input when 0 then 1 else @input end)
SELECT (CASE 25/0 when 0 then 1 else 25/0 end)
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)
Blog Archive
►
2010
(2)
►
February
(1)
►
January
(1)
▼
2009
(1)
▼
June
(1)
Solution to SQL Server Error "Divide by zero error...
►
2008
(1)
►
August
(1)
About Me
s13khan
SharePoint application developer. eCommerce and web portal expert.
View my complete profile