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

ÔÚSQLÖÐʹÓÃnow()µ¼ÖµÄÐÔÄÜϽµ(MySQL)

×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈ˰¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷½ÃæµÄÎÊÌâ¡£
×îºó°Ñ»³ÒɵÄÄ¿¹âÂäÔÚÁËSQL½áβ´¦µÄ>=now()ÉÏ£¬now()ÿ´Î¶¼ÐèÒª´ÓϵͳÖÐÈ¡£¬Òò´Ë¿ÉÄܻᵼÖÂÎÞ·¨Ê¹ÓÃquery cache¡£
Á˽âÁËÒ»ÏÂÐèÇó£¬Êµ¼ÊÕâÀï²¢²»ÐèÒªµ±Ê±µÄʱ¿Ì£¬Ö»ÐèÒªµ±ÌìµÄÈÕÆÚ¾ÍÐÐÁË¡£Òò´Ë½¨ÒéͬʰÑ>=now()¸Ä³É>=µ±Ç°ÈÕÆÚ£¬¶øµ±Ç°ÈÕÆÚÔÚ³ÌÐòÖÐÈ¡µÃ¡£
¹ûÈ»£¬ÐÔÄÜ´ó·ùÌá¸ß¡£


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL ÁÙʱ±íÓëÁÙʱ±äÁ¿±í

 
         ÔÚSQLServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£ÈçºÎÈ·¶¨Ê²Ã´Ê±ºòÓÃÁÙʱ±í£¬Ê²Ã´Ê±ºòÓñí±äÁ¿ÄØ£¿ÁÙʱ±íºÍ±í±äÁ¿¶¼ÓÐÌØ¶¨µÄÊÊÓû·¾³¡£
¡¡¡¡±í±äÁ¿
¡¡¡¡±äÁ¿¶ ......

Ò»¸öSQLÃæÊÔÌâ

 ÌâĿҪÇó
°¢ÀïbabaµÄÃæÊÔÌâ
ÓÐÈý¸ö±í
    ѧÉú±í  S 
          SID  SNAME
  ½Ìʦ¿Î±í T 
          TID  TNAME  TCL
  ³É¼¨±í  SC &n ......

»ñÈ¡SQL Server·þÎñÆ÷ÁбíµÄ¼¸ÖÖ·½·¨

Ò»¡¢ SQL DMO ÃèÊö£ºSQL Distributed Management Objects£¨SQL·Ö²¼Ê½¹ÜÀí¶ÔÏ󣩣¬´æÔÚÓÚSQLDMO.dllÎļþÖУ¬Êµ¼ÊÉÏÊÇÒ»¸öCOM ¶ÔÏó£¬Í¨¹ýµ÷ÓÃSQL DMOµÄListAvailableSQLServers·½·¨È¡µÃ¡£ ÁбíÀàÐÍ£ºÁоÙ×°ÓС°¿Í»§¶Ë¡±ºÍ¡°·þÎñ¶Ë¡±µÄ¼ÆËã»ú¡£ ÊÊÓÃÌõ¼þ£º×°ÓÐ SQL Server£¬ÇÒÓÐSQLDMO.dllÎļþ¡£ ËÙ¶È£ºÖÐ µ÷ÓÃʾÀý£ºGetS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ