FIX: ?? ???? ??? ??????? ?????? ??? ?? ??? ??????? ?????? getdate ??? ???? ???? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 925153 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50000210 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
  • ????????? ??????? ????? ???? ????????? ???????
  • ??????? ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ??????? ??????
  • ??????? ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ??????? ?? ??? ??? ??? ????? ??? ??????? ??????? ??? ????? ???? ??????? ??????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ??????? ???? getdate ?? ??????? ????? ?? Microsoft SQL Server 2005 ?? ????? ????? ??? ????? ??? ??. ????? ??? ??????? ??? ??????? ???? getdate ??? ???? ????.

?????? ?? ?? ????? ??? ??????? ?? Microsoft SQL Server 2000.

????

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.??? ?? ???? ????

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

??? ?? ???? ???? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ????? ????? ??? ??????? ??????.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

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

?? ??? ???? ????? ?????.

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? x 86 ?????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
logread.exe2005.90.2189.0398,112????? ?????? ??????: ??x 86
microsoft.analysisservices.adomdclient.dll9.0.2189.0543,520????? ?????? ??????: ??x 86
microsoft.analysisservices.deploymentengine.dll9.0.2189.0138,016????? ?????? ??????: ??x 86
microsoft.analysisservices.dll9.0.2189.01,215,264????? ?????? ??????: ??x 86
microsoft.sqlserver.mgdsqldumper.dll2005.90.2189.075,552????? ?????? ????22: 12x 86
microsoft.sqlserver.sqlenum.dll9.0.2189.0908,064????? ?????? ??????: ??x 86
msgprox.dll2005.90.2189.0197,920????? ?????? ????22: 12x 86
msmdlocal.dll9.0.2189.015,610,144????? ?????? ??????: ??x 86
msmdredir.dll9.0.2189.03,990,304????? ?????? ??????: 15x 86
replprov.dll2005.90.2189.0547,616????? ?????? ??????: ??x 86
replrec.dll2005.90.2189.0782,112????? ?????? ??????: ??x 86
sqlaccess.dll2005.90.2189.0347,936????? ?????? ??????: ??x 86
sqlagent90.exe2005.90.2189.0319,264????? ?????? ??????: 13x 86
sqlservr.exe2005.90.2189.028,962,136????? ?????? ??????: ??x 86
xpstar90.dll2005.90.2189.0292,640????? ?????? ??????: ??x 86
xpstar90.rll2005.90.2189.0152,864????? ?????? ??????: ??x 86
SQL Server 2005 ????? 64-??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
logread.exe2005.90.2189.0522,52808 ?????? ????03: 51x 64
microsoft.analysisservices.adomdclient.dll9.0.2189.0543,520????? ?????? ??????: ??x 86
microsoft.analysisservices.adomdclient.dll9.0.2189.0543,52008 ?????? ????03: 51x 86
microsoft.analysisservices.deploymentengine.dll9.0.2189.0138,016????? ?????? ??????: ??x 86
microsoft.analysisservices.dll9.0.2189.01,215,264????? ?????? ??????: ??x 86
microsoft.sqlserver.mgdsqldumper.dll2005.90.2189.075,552????? ?????? ????22: 12x 86
microsoft.sqlserver.mgdsqldumper.dll2005.90.2189.091,42408 ?????? ????03: 48x 64
microsoft.sqlserver.sqlenum.dll9.0.2189.0875,29608 ?????? ????03: 48x 86
msgprox.dll2005.90.2189.0259,36008 ?????? ????03: 50x 64
msmdlocal.dll9.0.2189.015,610,144????? ?????? ??????: ??x 86
msmdredir.dll9.0.2189.03,990,304????? ?????? ??????: 15x 86
replprov.dll2005.90.2189.0745,24808 ?????? ????03: 48x 64
replrec.dll2005.90.2189.01,008,41608 ?????? ????03: 48x 64
sqlaccess.dll2005.90.2189.0355,10408 ?????? ????03: 51x 86
sqlagent90.exe2005.90.2189.0390,94408 ?????? ????03: 51x 64
sqlservr.exe2005.90.2189.039,323,42408 ?????? ????03: 48x 64
xpstar90.dll2005.90.2189.0540,96008 ?????? ????03: 51x 64
xpstar90.rll2005.90.2189.0153,37608 ?????? ????03: 49x 64
SQL Server 2005 ??????? ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
logread.exe2005.90.2189.01,095,45608 ?????? ????02: 51IA-64
microsoft.analysisservices.adomdclient.dll9.0.2189.0543,520????? ?????? ??????: ??x 86
microsoft.analysisservices.adomdclient.dll9.0.2189.0543,52008 ?????? ????02: 50x 86
microsoft.analysisservices.deploymentengine.dll9.0.2189.0138,016????? ?????? ??????: ??x 86
microsoft.analysisservices.dll9.0.2189.01,215,264????? ?????? ??????: ??x 86
microsoft.sqlserver.mgdsqldumper.dll2005.90.2189.075,552????? ?????? ????22: 12x 86
microsoft.sqlserver.mgdsqldumper.dll2005.90.2189.0163,10408 ?????? ??????: 49IA-64
microsoft.sqlserver.sqlenum.dll9.0.2189.0875,29608 ?????? ????02: 51x 86
msgprox.dll2005.90.2189.0542,49608 ?????? ????02: 50IA-64
msmdlocal.dll9.0.2189.048,587,04008 ?????? ??????: 49IA-64
msmdredir.dll9.0.2189.06,237,47208 ?????? ????02: 52IA-64
replprov.dll2005.90.2189.01,617,18408 ?????? ????02: 51IA-64
replrec.dll2005.90.2189.02,141,47208 ?????? ????02: 51IA-64
sqlaccess.dll2005.90.2189.0349,47208 ?????? ????02: 50x 86
sqlagent90.exe2005.90.2189.01,143,58408 ?????? ????02: 51IA-64
sqlservr.exe2005.90.2189.072,232,22408 ?????? ????02: 50IA-64
xpstar90.dll2005.90.2189.0951,07208 ?????? ??????: 53IA-64
xpstar90.rll2005.90.2189.0152,35208 ?????? ??????: 49IA-64

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

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

????? ???? ???????? ???????? ??????? ?? SQL Server 2005. ????? ??????? <database>
Use <Database>
go
drop table temp_table
go

create table temp_table (a int, b char(100), c char(1))
go
set nocount on
go
declare @ret int
set @ret = 0
while (@ret < 10000)
begin
      set @ret = @ret + 1
      insert into temp_table values(@ret,@ret,'A')
      insert into temp_table values(@ret*2,@ret*2,'B')
      insert into temp_table values(@ret*3,@ret*3,'C')
      insert into temp_table values(@ret*4,@ret*4,'D')
end
go

select case
      when c = 'A'
            then getdate()
      when c = 'B'
            then getdate()
      when c = 'D' 
            then getdate()
      end as Status,getdate(),a,b,c
from temp_table order by A
?????? ??????? <Database> ?? ??? ????? ????????.

???????

???? ???????: 925153 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.6
????? ???
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kbautohotfix kbsql2005tsql kbexpertiseadvanced kbhotfixserver kbqfe kbpubtypekc KB925153 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????925153

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

 

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