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

´óÊý¾ÝÁ¿Ï¿ìËÙ»ñÈ¡ SQL Server Êý¾Ý¿â±í¼Ç¼ÊýµÄ·½·¨

ÔÚÊý¾Ý¿âÓ¦ÓõÄÉè¼ÆÖУ¬ÎÒÃÇÍùÍù»áÐèÒª»ñȡijЩ±íµÄ¼Ç¼×ÜÊý£¬ÓÃÓÚÅжϱíµÄ¼Ç¼×ÜÊýÊÇ·ñ¹ý´ó£¬ÊÇ·ñÐèÒª±¸·ÝÊý¾ÝµÈ¡£ÎÒÃÇͨ³£µÄ×ö·¨ÊÇ£ºselect count(*) as c from tableA ¡£È»¶ø¶ÔÓڼǼÊý¾Þ´óµÄ±í£¬ÉÏÊö×ö·¨½«»á·Ç³£ºÄʱ¡£ÔÚDELL 4400 ·þÎñÆ÷ÉÏ×öÊÔÑ飬MS Sqlserver 2000 Êý¾Ý¿â¶ÔÓÚ100Íò¼Ç¼µÄ¼òµ¥Êý¾Ý±íÖ´ÐÐÉÏÊöÓï¾ä£¬Ê±¼äÔÚ1·ÖÖÓÒÔÉÏ¡£Èç¹ûÔÚ±íµÄij¸ö×Ö¶ÎÉÏ×ö¾Û´ØË÷Òý£¬µÚÒ»´ÎÖ´ÐиÃÓï¾äµÄʱ¼äºÍûÓÐË÷ÒýµÄʱ¼ä²î²»¶à£¬Ö®ºóÖ´ÐÐÉÏÊöÓï¾ä£¬ËٶȺܿ죬ÔÚ1ÃëÖÐÒÔÄÚ£¬µ«µ±±íµÄ¼Ç¼Êý·¢Éú½Ï´ó±ä»¯ºó£¬ÔÙÖ´ÐиÃÓï¾äÓֻᾭÀúÒ»´ÎºÄʱµÄ¹ý³Ì¡£¶øÇÒ²»ÊÇÿ¸ö±í¶¼ÊʺÏ×ö¾Û´ØË÷ÒýµÄ£¬¶ÔÓÚÊýÁ¿¾Þ´óµÄ±í£¬Èç¹ûÐèÒª¾­³£Ôöɾ²Ù×÷£¬½¨¾Û´ØË÷ÒýÊÇÒ»¸öºÜ²»Ã÷ÖǵÄ×ö·¨£¬½«»á¼«´óµÄÓ°ÏìÔöɾµÄËٶȡ£ÄÇôÓÐûÓÐÒ»¸ö±È½Ï¼òµ¥µÄ·½·¨¿ìËÙ»ñÈ¡±íµÄ¼Ç¼×ÜÊýÄØ£¿´ð°¸ÊÇÓеġ£
ÔÚMS SQL Êý¾Ý¿âÖÐÿ¸ö±í¶¼ÔÚsysindexes ϵͳ±íÖÐÓµÓÐÖÁÉÙÒ»Ìõ¼Ç¼£¬¸Ã¼Ç¼ÖеÄrows ×ֶλᶨʱ¼Ç¼±íµÄ¼Ç¼×ÜÊý¡£
ÏÂÃæÊÇsysindexes ±íµÄÏà¹Ø¼Ç¼µÄº¬Ò壺
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
id int ±íID(Èç¹û indid = 0 »ò255)¡£·ñÔòΪË÷ÒýËùÊô±íµÄID
Indid smallint Ë÷ÒýID£º
0£½±í
1£½¾Û´ØË÷Òý
>1£½·Ç¾Û´ØË÷Òý
255£½¾ßÓÐtext»òimageÊý¾ÝµÄ±íÌõÄ¿¡£
rows int »ùÓÚindid=0 ºÍ indid=1µØÊý¾Ý¼¶ÐÐÊý£¬¸ÃÖµ¶ÔÓÚindid>1ÖØ ¸´¡£Èç¹ûindid=255£¬rowsÉèÖÃΪ0¡£
µ±±íûÓо۴ØË÷Òýʱ£¬Indid = 0 ·ñÔòΪ 1¡£
ÄÇôÏÖÔÚ´ó¼ÒÓ¦¸ÃÖªµÀÈçºÎ»ñÈ¡±íµÄ¼Ç¼×ÜÊýÁË£¬Ö»ÐèÖ´ÐÐÈçÏÂÓï¾ä£º
select rows from sysindexes where id = object_id('tablename') and indid in (0,1)
¸Ã·½·¨»ñÈ¡±íµÄ¼Ç¼×ÜÊýµÄËٶȷdz£¿ì£¬ÔÚºÁÃ뼶¾Í¿ÉÒÔÍê³É£¬Ïà±Èselect count(*) Òª¿ìÉÏÊýÍò±¶£¬µ«ÊÇ´ó¼ÒÔÚÔËÓø÷½·¨ÊÇÒ»¶¨ÒªÖ÷Òª£¬¸Ã·½·¨µÃµ½µÄ±íµÄ×ܼǼÊý²»ÊÇÒ»¸ö¾«È·Öµ£¬Ô­ÒòÊÇMS SQL ²¢²»ÊÇʵʱ¸üиÃ×ֶεÄÖµ£¬¶øÊǶ¨Ê±¸üУ¬µ±´Óʵ¼ùÀ´¿´¸ÃÖµºÍ¾«È·ÖµÒ»°ãÎó²î²»´ó£¬Èç¹ûÄãÏ£Íû¿ìËٵĴÖÂÔ¹ÀËã±íµÄ´óС£¬½¨ÒéÄã²ÉÓø÷½·¨¡£Èç¹ûÄãÏ£ÍûµÃµ½¾«È·Öµ£¬ÄÇôÇëÔÚÖ´ÐÐÉÏÊöÓï¾äÇ°Ö´ÐÐDBCC UpdateUSAGE(DatabaseName,[TABLENAME]) WITH ROW_COUNTS Ç¿ÖƸüиÃ×ֶεÄÖµ£¬µ«ÕâÑùµÚÒ»´Î¸üÐÂʱ»áºÄ·Ñ´óÁ¿µÄʱ¼ä£¬ÕâÑù×öµÄЧ¹ûºÍ½¨Óо۴ØË÷ÒýµÄ±í select count (*) Ч¹ûÏà²î²»´ó£¬ËùÒÔÈç¹ûÄãÏ£ÍûÏà¶Ô¿ìËٵصõ½¾«È·µÄ±íµÄ¼Ç¼×ÜÊý£¬ÄÇôÄãÓÐÁ½ÖÖÑ¡Ôñ£¬½¨¾Û´ØË÷Òý»òÕßÏÈDBCC ÔÙʹÓÃÉÏÊö·½·¨


Ïà¹ØÎĵµ£º

SQL ×¢È붶´Ïà¹Ø֪ʶÕûÀí

 ÉÏÉϸöÐÇÆÚ£¬ÓÐÈË·´À¡£¬CSDNÓÐSQL×¢È붶´£¬º¹ÑÕ£¬¼¸ÄêǰΪSQL×¢È붶´£¬²¿ÃÅרÃŶÔËùÓдúÂë×ö¹ýÒ»´Î·Ç³£´óµÄ¼ì²é£¬¾¹È»ÄǴμì²é»¹ÓÐÒÅ©µÄµØ·½¡£×î½üÕ⼸¸öÐÇÆÚ£¬¾ÍÊÇÒ»Ö±ÔÙ¶Ô´úÂë×öÔٴθ´²é£¬¿´ÓÐûÓÐSQL×¢È붶´¡£
        ´æÔÚSQL×¢È붶´£¬¾ÍÒòΪÄãµÄSQLÓï¾äÊÇ×Ô¼ºÆ´´ ......

pl/sql ʵÏֹ鲢Ëã·¨

ÔÚÍøÉÏ¿´µ½¹ØÓڹ鲢Ëã·¨£¬Ã»ÓÐÊý¾Ý¿â¼¶µÄ£¬µ±È»Êý¾Ý¼¶µÄËã·¨¶ÔÓÚÊý¾Ý¿âÀ´Ëµ¾ÍÊÇÒ»¸öÅÅÐò¡£½ñÌìдһ¸öpl/sqlµÄ¹é²¢Ëã·¨¡£
¹é²¢µÄËã·¨ºÜÈÝÒ×Àí½â£¬ÍøÉϺÜÏêϸ£¬ÏÖÖ»°ÑÔ´ÂëÌù³öÀ´¡£
£¨°üÉùÃ÷²¿·Ö£©
CREATE OR REPLACE PACKAGE PG_MERGESORT IS
  -- Author  : wealth_khb@126.com
  -- Created : 2009-10- ......

SQLÓï¾ä²Ù×÷È«¼¯


SQLÓï¾ä²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&n ......

·ÀÖ¹sql×¢È룬¿çÕ¾½Å±¾

sql×¢Èë·ÀÖ¹µÄ·½Ê½£º
1.×î¸ù±¾µÄ°ì·¨¾ÍÊÇʹÓÃÔ¤±àÒëµÄ·½Ê½½øÐÐÊý¾Ý¿â²Ù×÷¡£¼´Ê±Ê¹Ó㿵ķ½Ê½¡£
2.ʹÓùýÂËÀà¡£
·ÀÖ¹¿çÕ¾½Å±¾µÄ·½Ê½£º
1.ÔÚÊý¾Ý¼Èë½×¶Î½øÐйýÂË£¬µ«ÊÇÕâÖÖ·½Ê½»áÊǶªÊ§Ò»Ð©Êý¾Ý¡£
2. ÔÚÊý¾Ýչʾ½×¶Î¡£Ê¹ÓñêÇ©°üº¬£¬innerhtml µÄ·½Ê½¡£ ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹Øϵ
    Ã¿¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼­·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØƽºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ