JTDSÁ¬½ÓSQL Server Óöµ½µÄÎÊÌâ
½ñÌìÔÚÓÃJTDSÁ¬½ÓSQL Server ʱºò£¬Óöµ½¼¸¸öÎÊÌ⣬¼Ç¼ÈçÏ£º
error while performing database login with the jtds driver:
network error ioexception:connection refused: connect
È»ºó²é¿´¶Ë¿Ú£¬ÔÀ´ÊÇ1433¶Ë¿Úδ´ò¿ª£¬È»ºóÔÚSQL Server configuration ManagerϵÄTCP\IPÖÐÆôÓÃ1433¶Ë¿Ú£¬ÖØÆôSQL Server·þÎñ£¬netstat -a -n ²é¿´¶Ë¿Ú£¬1433´ËʱÒѾ´ò¿ª¡£
ÔٴΓtest driver”½á¹ûÓÖ³öÏÖÎÊÌ⣺
±¾ÈËÏë³¢ÊÔ¿ªÆôSQL Server µÄVIA£¬½á¹ûÖØÆôSQL Serverʱ£¬²»ÄÜÕý³£Æô¶¯~£¡
֮ǰͨ¹ýjdbcÁ¬½Ó³É¹¦¹ý£¬ÏÖÔÚÊÔһϣ¬½á¹û£º
½â¾ö°ì·¨£º
1. ÏȽ«VIA½ûÓã¬È»ºó´ò¿ªSQL Server Configuration Manager->MSSQL ServerµÄÐÒé
->TCP/IP->IPµØÖ·
2. ²é¿´Á¬¸öIPµØÖ·ºÍ¶Ë¿Ú£¬¾¹ýÉÏÊöµÄ´íÎó£¬Ó¦¸Ã¶Ë¿ÚÉèÖÃûÓÐÎÊÌâµÄ£¬Îª1433£¬µ«ÊÇÎÊ
Ìâ¾Í³öÔÚÁ½¸öIPµØÖ·ÉÏ£¬¼ì²éʱºòÆôÓÃÁËIPµØÖ·£¬²¢ÇÒÖ»¿ÉÒÔÆôÓÃÒ»¸öŶ£¬²»È»¾Í»á³öÏÖ
windows socket errorµÄ´íÎ󣬯ôÓÃÒ»¸öÖ®ºóÖØÆôÒ»ÏÂSQL Server·þÎñ£¬JTDSºÍJDBCÁ¬
½Ó¶¼Õý³£~£¡À§ÈÅÒ»ÍíµÄÎÊÌâ½â¾ö~£¡
Ïà¹ØÎĵµ£º
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
µÚÒ»Õ£ºÐÅÏ¢Ìåϵ½á¹¹ÔÔò
¸ù¾ÝÒÔÏÂ7¸öÏ໥ÒÀÀµµÄÊý¾Ý´æ´¢Ä¿±êÉè¼ÆºÍÆÀ¹ÀÈκÎÊý¾Ý´æ´¢£º
l ¼òµ¥ÐÔ£»
l ÓÐÓÃÐÔ
l Êý¾ÝÍêÕûÐÔ
l ÐÔÄÜ
l ¿ÉÓÃÐÔ
l ¿ÉÀ©Õ¹ÐÔ
l °²È«ÐÔ
¼Ü¹¹Éè¼ÆÔÔò
l ±ÜÃâ¹ýÓÚ¸´ÔÓ
l ¾«ÐÄÌôÑ¡¼ü
l Ê÷Á¢¿ÉÑ¡Êý¾Ý
l ÊµÏ ......
ÔÚEssbaseÖÐʹÓÃMDXÖ»ÄÜÓÃÓÚ²éѯ£¬Éв»ÄÜÀ´²Ù×÷Cube£¨MS SSASÖпÉÒÔʹÓÃMDXÀ´²Ù×÷CubeµÄ£©£¬ËùÒÔÕâÀïֻѧϰMDXµÄSelectÓï¾ä¡£
ÔÚѧϰµÄ¹ý³ÌÖУ¬ÎÒ¾õµÃ×îÓÐÄѶȵĵط½ÓÐÁ½¸ö¡£
Ò»ÊÇ£¬¶ÔOLAP¶àάµÄÀí½â¡£ÈçͬѧϰSQLÒ»Ñù£¬SQL×÷ÓõĶÔÏóÊÇ±í£¬±íµÄ½á¹¹¶¼ÊǶþάµÄ£¬±êʶÐÐÁм´¿É£»µ«ÊÇMDX×÷ÓõĶÔÏóÊǶàάÊý¾Ý¿â£¬ÄÇ ......
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-05-12 19:43:03
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10 ......