Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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'

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


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


Ïà¹ØÎÊ´ð£º

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

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

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

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

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

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

ÇëÎÊ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ºÅ