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

SQLÓï¾äÖ´ÐÐЧÂʼ°ÐÔÄܲâÊÔ

д³ÌÐòµÄÈË£¬ÍùÍùÐèÒª·ÖÎöËùдµÄSQLÓï¾äÊÇ·ñÒѾ­ÓÅ»¯¹ýÁË£¬·þÎñÆ÷µÄÏìӦʱ¼äÓжà¿ì£¬Õâ¸öʱºò¾ÍÐèÒªÓõ½SQLµÄSTATISTICS״ֵ̬À´²é¿´ÁË¡£
    Í¨¹ýÉèÖÃSTATISTICSÎÒÃÇ¿ÉÒԲ鿴ִÐÐSQLʱµÄϵͳÇé¿ö¡£Ñ¡ÏîÓÐPROFILE£¬IO £¬TIME¡£½éÉÜÈçÏ£º
SET STATISTICS PROFILE ON£ºÏÔʾ·ÖÎö¡¢±àÒëºÍÖ´ÐвéѯËùÐèµÄʱ¼ä£¨ÒÔºÁÃëΪµ¥Î»£©¡£ 
SET STATISTICS IO ON£º±¨¸æÓëÓï¾äÄÚÒýÓõÄÿ¸ö±íµÄɨÃèÊý¡¢Âß¼­¶ÁÈ¡Êý£¨ÔÚ¸ßËÙ»º´æÖзÃÎʵÄÒ³Êý£©ºÍÎïÀí¶ÁÈ¡Êý£¨·ÃÎÊ´ÅÅ̵ĴÎÊý£©ÓйصÄÐÅÏ¢¡£ 
SET STATISTICS TIME ON£ºÏÔʾÿ¸ö²éѯִÐкóµÄ½á¹û¼¯£¬´ú±í²éѯִÐеÄÅäÖÃÎļþ¡£
    Ê¹Ó÷½·¨£º´ò¿ªSQL SERVER ²éѯ·ÖÎöÆ÷£¬ÊäÈëÒÔÏÂÓï¾ä£º
SET STATISTICS PROFILE ON 
SET STATISTICS IO ON 
SET STATISTICS TIME ON 
GO /*--ÄãµÄSQL½Å±¾¿ªÊ¼*/
SELECT [TestCase] from [TestCaseSelect] 
GO /*--ÄãµÄSQL½Å±¾½áÊø*/
SET STATISTICS PROFILE OFF 
SET STATISTICS IO OFF 
SET STATISTICS TIME OFF
    ÁíÍ⣬Ҳ¿ÉÒÔͨ¹ýÊÖ¹¤Ìí¼ÓÓï¾ä£¬¼ÆËãÖ´ÐÐʱ¼äÀ´²é¿´Ö´ÐÐÓï¾ä»¨·ÑÁ˵Äʱ¼ä£¬ÒÔÅжϸÃÌõSQLÓï¾äµÄЧÂÊÈçºÎ£º
declare @d datetime
set @d=getdate()
/*ÄãµÄSQL½Å±¾¿ªÊ¼*/
SELECT [TestCase] from [TestCaseSelect] 
/*ÄãµÄSQL½Å±¾½áÊø*/
select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate()) 
trackback: http://www.piaoyi.org/database/sql-statistics.html


Ïà¹ØÎĵµ£º

SQLÓïÑԵIJ¼¾ÖºÍIllegalArgumentException

ºÍjava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinalÕ½¶·Á˰ëÌ죬º¹°¡£¡
ʹÓÃjpa + strut+ hibernate ¾Í±¨org.hibernate.QueryException: JPA-style positional param was not an integral ordinal
Ò»°ã°ÑhqlÓï¾äдÔÚÒ»ÐУ¬»áºÜ³¤£¬ÔÚideÖÐÐèÒ ......

sql server ÖÐÁÙʱ±íÓë±í±äÁ¿µÄÇø±ð

 
ÎÒÃÇÔÚÊý¾Ý¿âÖÐʹÓñíµÄʱºò,¾­³£»áÓöµ½Á½ÖÖʹÓñíµÄ·½·¨,·Ö±ð¾ÍÊÇʹÓÃÁÙʱ±í¼°±í±äÁ¿¡£ÔÚʵ¼ÊʹÓõÄʱºò£¬ÎÒÃÇÈçºÎÁé»îµÄÔÚ´æ´¢¹ý³ÌÖÐÔËÓÃËüÃÇ£¬ËäÈ»ËüÃÇʵÏֵŦÄÜ»ù±¾ÉÏÊÇÒ»ÑùµÄ£¬¿ÉÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐÓÐʱºòȥʹÓÃÁÙʱ±í¶ø²»Ê¹Óñí±äÁ¿£¬ÓÐʱºòȥʹÓñí±äÁ¿¶ø²»Ê¹ÓÃÁÙʱ±íÄØ?
¡¡¡¡ÁÙʱ±í
¡¡¡¡ÁÙʱ±íÓëÓÀ¾Ã± ......

ÈçºÎÓÃSQLÓï¾äÔÚÁ½¸öÊý¾Ý¿â¼ä¸´ÖÆ´æ´¢¹ý³Ì

 --1.ÔÚÄ¿±ê·þÎñÆ÷ÉϽ¨Á¢Èç϶ÔÏó(±»Í¬²½µÄ·þÎñÆ÷)  
   
  if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[sys_syscomments_bak]')   and   OBJECTPROPERTY(id,   N'IsUserTable')   ......

¾¡Á¿±ÜÃâÔÚSQLÓï¾äÖÐʹÓÃLIKE

----start
    Ç°Ã棬ÎÒÃǽéÉÜÁË ¾¡Á¿±ÜÃâÔÚSQLÓï¾äµÄWHERE×Ó¾äÖÐʹÓú¯Êý£¬ÒòΪÕâÑù×ö»áʹ¸Ã×Ö¶ÎÉϵÄË÷ÒýʧЧ£¬Ó°ÏìSQLÓï¾äµÄÐÔÄÜ¡£»ùÓÚͬÑùµÄµÀÀí£¬ÎÒÃÇÒ²Ó¦¸Ã±ÜÃâʹÓÃLIKE¡£¿¼ÂÇÏÂÃæµÄÇé¿ö£º
CREATE TABLE USER
(
NAME VARCHAR(20) NOT NULL,---ÐÕÃû
MYNUMBER VARCHAR(18)---Éí·ÝÖ¤ºÅÂë
);&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ