当我运行以下查询[SELECT DATENAME(MONTH,GETDATE())]时,理想情况下它应该返回值为’September’但其返回值为’09’.我在MS sql Server 2005上运行此查询.我需要配置MS sql Server 2005吗？
请查找sql Server 2005的详细信息
Component Name Version -------------------------------------------------------------------- Microsoft sql Server Management Stu@R_404_410@ 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.3790.3959 Microsoft .NET Framework 2.0.50727.42 Operating System 5.2.3790
