FIX: ???? 0 ????? ????? ??????? ???? ?? ???? ?? 0

?????? ????????? ?????? ?????????
???? ???????: 285544 - ??? ???????? ???? ????? ????? ??? ???????.
BUG #: 203148 (SHILOH_bugs)
????? ???? | ?? ????

???????

??? ??????? ????? ?????? ???? ?? ???? ??? ??? ?????? 0 ?????? ??? 0 ????? (- 0) ??? ?????.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000

???? ??????

???? ?? 0 ??? ????? ?????? ????? ?????? ??? ?? ????? 0; ??? ???? ??????:
declare @v1 dec(10, 2), @v2 dec(2, 1), @v3 dec (10,2) 
-- @v3 is the result of @v1/@v2
select @v1 = 0.0, @v2 = -1.0
if @v1 = 0  
   select @v3 = 0.0
else
   select @v3 = @v1 / @v2
				

?????

???? Microsoft ?? ??? ????? ?? SQL Server 2000. ?? ????? ??? ??????? ???? ??? ?? SQL Server 2000 Service Pack 1.

??????? ????

???? SQL ??? ?????? ???? ?????? (- 0) ????? 0? ????? ?????? ???? ?????? (- 0) ?? ??? 0. ??? ???? ??????? ??? ???????
   declare @v1 dec(10, 2), @v2 dec(2, 1)
   select @v1 = 0.0, @v2 = -1.0
   if @v1 / @v2 = 0  
      print 'equals zero'
   else
      print 'not equal zero'
				
???? ??????? ???????:
   not equal zero 
				
?????? ??? ??????? ?????? ??? ??????? ???????? ?? SQL Server 7.0 ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
275608?????? ?????? FIX: ??? ??????? ?? ???? ?? ??????? ?? ??????? ??????? ????? ????? ??? ??????

???????

???? ???????: 285544 - ????? ??? ??????: 20/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB285544 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????285544

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com