Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇÉÓÃSQL ServerÈÕÆÚÀàÐÍÊý¾Ý¶þ½øÖÆÊä³ö¼ÆËãʱ¼ä²î

1¡¢SQL ServerÈÕÆÚÊý¾Ý¿âÄÚ²¿±íʾ¼°²éѯÊä³ö£º
SQL ServerÄÚ²¿¶ÔDateTimeÀàÐ͵ıíʾÊÇÓÃ8¸ö×Ö½ÚÀ´±íʾ£¬ÆäÖÐǰ4¸ö×Ö½Ú±íʾµÄÊýֵΪ×Ô1900Äê1ÔÂ1ÈÕÁãʱÒÔÀ´µÄÌìÊý£¬ºóËĸö×Ö½ÚÊÇÌìÊýÖ®ÍâµÄÓжàÉÙ¸ö1/300Ã룬ÕâҲ˵Ã÷SQL ServerÄÚ²¿±íʾʱ¼äµÄ¾«¶ÈΪ1/300Ã룬Լ3.3ºÁÃë¡£
³£¹æµÄSQL²éѯ£¬Õý³£ÈÕÆÚÊä³ö¸ñʽΪ:yyyy-MM-dd hh:mm:ss.SSS£¬ÕâÒ²ÊÇÖÐÎIJÙ×÷ϵͳµÄÈÕÆÚ¸ñʽ£¬¿ÉÒÔͨ¹ýÐ޸IJÙ×÷ϵͳÈÕÆÚ±í´ï¸ñʽÀ´Ó°ÏìSQL ServerȱʡµÄÈÕÆÚÊä³ö¸ñʽ¡£µ«ÊÇ£¬ÓÐЩʱºòȱʡµÄÈÕÆÚÊä³ö¸ñʽ²¢²»ÊÇÎÒÃÇÐèÒªµÄ£¬ÌرðÊÇ»ùÓÚʱ¼ä²îµÄÓ¦ÓÃÐèÇó¡£
2¡¢Ó¦ÓÃÐèÇó£º
»ùÓÚһϵÁÐʱ¼äµãµÄÊý¾Ý¼Ç¼·ÖÎö¡¢Í³¼ÆÄ³ÖÖ½á¹û¡£±ÈÈçGPS¶¨Î»É豸°´Ò»¶¨Ê±¼ä¼ä¸ô»Ø´«Î»ÖÃÊý¾Ý²¢¼Ç¼µ½Êý¾Ý¿âÖУ¬Êý¾Ý°üÀ¨¾­Î³¶È¡¢Ê±¼ä¡¢Ëٶȵȣ¬ÏÖÔÚÐèÒª»ùÓÚÕâЩ»Ø´«Êý¾Ýͳ¼ÆÊÇ·ñÔÚijµØÓÐÍ£Áô£¬Í£Áôʱ¼ä¡¢¿ªÊ¼Ê±¼ä¡¢½áÊøÊ±¼ä¡£Í£Áô±êÖ¾ÊÇËÙ¶ÈΪ0¡£ÏÔʾ£¬ÕâÐèÒª¸ù¾ÝÊý¾Ý¼Ç¼֮¼äµÄ²îÖµ×öͳ¼Æ¼ÆËã¡£
3¡¢ÊʺÏÐèÇóµÄÊä³ö¼°×ª»»¡¢´¦Àí£º
Èç¹û°´ÕÕȱʡµÄSQL ServerÈÕÆÚÊä³ö¸ñʽ£¬Êä³öÄÚÈÝ¿ÉÓ³ÉäΪ±à³ÌÓïÑÔÏà¹ØµÄÊý¾ÝÀàÐÍ£¬ÈçJava¿ÉÒÔÊÇString¡¢Date£¬×ªÎªÎªDateÓÐÒ»¶¨Í³¼ÆÊý¾ÝÁ¿µÄ»°£¬Õâ¸öת»»±¾Éí¾ÍÊǵÍЧºÍºÄʱµÄ£¬Êµ¼Ê¹ý³Ì¿ÉÄÜÊÇÏÈ´ÓSQL ServerÄÚ²¿±íʾת»»Îªyyyy-MM-dd hh:mm:ss.SSS×Ö·û´®£¬ÔÙ´ÓÕâ¸ö×Ö·û´®×ª»»ÎªDate£»×÷ΪStringʹÓÃÒ²ÐèҪת»»ÎªDateÖ®ºó²Å¿ÉÒÔ×öʱ¼ä²îÔËË㣬ͬÑùµÍЧ¡£
SQL ServerÄÚ²¿Êý¾Ý±íʾ¸ñʽÆäʵÒѾ­Êʺϱí´ïʱ¼ä²îÁË£¬ÊDz»ÊÇÄÜÖ±½ÓÀûÓá£SQL ServerÓÐcastº¯Êý£¬¿ÉÒÔ½«ÈÕÆÚÊä³öΪ¶þ½øÖÆÊý¾Ý¡£È磺
select longi, lati, speed, cast(gpsDate as binary(8)) as gpsDate from loc_history
ºóÐø´¦Àí´úÂëÆ¬¶ÎΪ£º
float lon = rs.getFloat("longi");
float lat = rs.getFloat("lati");
byte time[] = rs.getBytes("gpsDate");
»ñµÃ¾­Î³¶È¡¢Ê±¼ä¶þ½øÖƱíʾ
int days = ((time[0] & 0x00ff) << 24) + ((time[1] & 0x00ff) << 16)
                    + ((time[2] & 0x00ff) << 8) + (time[3] & 0x00ff);
int seconds = ((time[4] & 0x00ff) << 24) + ((time[5] & 0x00ff) << 16)
                    + ((time[6] & 0x00f


Ïà¹ØÎĵµ£º

Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé:

¡¡¡¡
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01','yyyy-mm-dd');
¡¡¡¡¡ôÔÚ¹ýÂËÌõ¼þÖУ¬¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐë·ÅÔÚwhere×Ó¾äµÄĩβ;
¡¡¡¡from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖа ......

Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé

from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£
 
¡¡¡¡Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé:
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01',' ......

SQL²éÑ¯ÖØ¸´Êý¾ÝºÍÇå³ýÖØ¸´Êý¾Ý


ÓÐÀý±í£ºemp
emp_no   name    age    
    001           Tom      17    
    002       &nb ......

SQLÓ¦ÓÃÈÕÖ¾

UPDATe [Sale_Goods]  SET [Catalog33_ID] = [Catalog].[ID]
from  [Sale_Goods]
LEFT OUTER JOIN [chdy222] ON [Sale_Goods].[Code] = [chdy222].[ID]
LEFT OUTER JOIN [Catalog] ON [chdy222].[ufidaname] = [Catalog].[Name] and [Catalog].[Type]=33
WHERE [Catalog].[ID] IS NOT NULL ......

ÈçºÎ²é¿´SQL Server²¹¶¡°æ±¾

ÈçºÎ²é¿´SQL Server²¹¶¡°æ±¾  [http://www.cnblogs.com/yitian/articles/1285021.html]
1¡¢ÓÃIsql»òÕßSQL²éѯ·ÖÎöÆ÷µÇ¼µ½SQL Server£¬Èç¹ûÊÇÓÃIsql£¬ÇëÔÚcmd´°¿ÚÊäÈëisql -U sa,È»ºóÊäÈëÃÜÂ룬½øÈ룻Èç¹ûÊÇÓÃSQL²éѯ·ÖÎöÆ÷£¬Çë´Ó³ÌÐòÖÐÆô¶¯£¬ÊäÈësaºÍÃÜÂ루Ҳ¿ÉÒÔÓÃwindowsÑéÖ¤£©¡£
2¡¢ÔÚISQLÖÐÊäÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ