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

Ò»¸öSQL Óï¾ä£¿

±¾ÈËÒª²éѯij¸öʱ¼ä¶ÎµÄÊý¾Ý
±íµÄ½á¹¹ÈçÏ£ºÊ±¼äµã ÊýÖµ1
ʱ¼äµãÊÇ×Ö·ûÐÍ
2010-02-25 10:23:25.967 23.432
2010-02-25 10:23:26.967 23.439
2010-02-25 10:23:27.967 23.482
2010-02-25 10:23:28.967 23.432
2010-02-25 10:23:29.967 23.332
2010-02-25 10:23:30.967 23.432
2010-02-25 10:23:31.967 23.400

select cast(²É¼¯µÄʱ¼äµã as datetime) AS ASDF£¬ÊýÖµ

from ²âÊÔ±í2010Äê02ÔÂ25ÈÕ

where 2010-02-05 10:23:25 967 <cast(²É¼¯µÄʱ¼äµã as datetime)

±¨´í £¿
SQL code:
select ²É¼¯µÄʱ¼äµã AS ASDF£¬ÊýÖµ from [²âÊÔ±í2010Äê02ÔÂ25ÈÕ]
where ²É¼¯µÄʱ¼äµã>'2010-02-05 10:23:25 967'


ÒýÓÃ
SQL codeselect ²É¼¯µÄʱ¼äµãAS ASDF£¬ÊýÖµfrom[²âÊÔ±í2010Äê02ÔÂ25ÈÕ]where ²É¼¯µÄʱ¼äµã>'2010-02-05 10:23:25 967'


£¬ Õâ¸ö±êµã´íÁË

ÒýÓÃ
SQL codeselect ²É¼¯µÄʱ¼äµãAS ASDF£¬ÊýÖµfrom[²âÊÔ±í2010Äê02ÔÂ25ÈÕ]where ²É¼¯µÄʱ¼äµã>'2010-02-05 10:23:25 967'


×Ö·ûÐÍ ²»ÄܱȽϰÉ

ÒýÓÃ
ÒýÓà 1 Â¥ jiangshun µÄ»Ø¸´:
SQL codeselect ²É¼¯µÄʱ¼äµãAS ASDF£¬ÊýÖµfrom[²âÊÔ±í2010Äê02ÔÂ25ÈÕ]where ²É¼¯µÄʱ¼äµã>'2010-02-05 10:23:25 967'

×Ö·ûÐÍ ²»ÄܱȽϰÉ


Èç¹ûÊý¾ÝÄÚÈÝ·ûºÏÈÕÆÚ¸ñʽ£¬»á×Ô¶


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇëÎÊASPÈçºÎÁ¬½Ó¶à¸öSQL SERVER£¿ - Web ¿ª·¢ / ASP

ÓÐÁ½¸ö»òÒÔÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÈçºÎÓÃASP¼ì²âÁ¬½ÓËٶȲ¢Á¬½Ó×î¿ìµÄMSSQLÊý¾Ý¿â£¿

ÓÐÕâÑùµÄASPº¯ÊýÂð£¿ÎÒGOOGLEÁËһϣ¬ÕÒ²»µ½¡£

PHP+MYSQLÏÂÓÐÕâÖÖÀý×Ó£º
PHP code:

Example:
$wgDBservers = array(
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ