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

sqlserver count,order by ²éѯÂý

±íÖÐÊý¾Ý 700ÍòÌõ×óÓÒ£¬29¸ö×ֶΣ¬×Ô¶¯Ôö³¤ÁÐÉèΪÖ÷¼ü£¬ ʹÓÃcount£¨1£© ²éѯ×ÜÌõÊýÐèÒª1·ÖÖÓ£¬
select top 1000 ×Ö¶ÎÃû  from ±í order by ʱ¼ä(¸Ã×Ö¶ÎÓÐÖØ¸´ÖµºÍnullÖµ)  ÕâÑùµÄÓï¾ä²éѯ¸üÊÇÂýµÃ»ù±¾²é²»³öÀ´¡£¶øÇÒ¾ÍÊÇÔÚ×Ô¼ºµÄ±¾»ú²âÊԵġ£²»ÖªµÀÊÇʲôԭÒòÇë¸÷λ´Í½Ì¡£
create index  at  time

¶Ô ʱ¼ä½¨Á¢¸öË÷ÒýÊÔÊÔ

Ò»ÊÇË÷Òý£¡

»¹ÓÐÊÔÒ»ÏÂÓ÷ÖÇø±í£¡
SQL code:
ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖ¶Ô±íµÄºáÏò·Ö¸î£¬Sql server 2005ÆóÒµ°æºÍÖ®ºóµÄSql server°æ±¾²ÅÌṩÕâÖÖ¼¼Êõ£¬ÕâÖÖ¶Ô±íµÄºáÏò·Ö¸î²»Í¬ÓÚ2000Öеıí·Ö¸î£¬Ëü¶Ô·ÃÎÊÓû§ÊÇ͸Ã÷µÄ£¬Óû§²¢²»»á¸Ð¾õµÄ±í±»ºáÏò·Ö¸îÁË¡££¨2000ÖеıíºáÏò·Ö¸îÊǽ¨n¸ö±íÀýÈ簴ʱ¼ä½¨±íÿÔÂÒ»¸ö±í£¬±íÃû²»Í¬£¬×îºóÐèÒª×öÒ»¸ö´óÊÓͼ£©

¹ØÓÚ¾ßÌåµÄÈçºÎ×ö·ÖÇø£¬Çë²Î¿¼Êý¾Ý¿â·ÖÇøÑÝÁ·http://www.cnblogs.com/yukaizhao/archive/2008/05/07/sql_partition_test.html

ΪʲôҪ·ÖÇø£¿
ÏÔ¶øÒ×¼û·ÖÇøÊÇΪÁËÌá¸ßÊý¾Ý¿âµÄ¶ÁдÐÔÄÜ£¬Ìá¸ßÊý¾Ý¿âµÄЧÂÊ£»

·ÖÇøÊÇ·ñ×ÜÊÇ¿ÉÒÔÌá¸ßЧÂÊ£¿
·ÖÇøÊÇÒ»°ÑË«Èн££¬²¢²»×ÜÄÜÌá¸ßЧÂÊ£¬ÕâºÍ¾ßÌåÇé¿öÓйØÏµ¡£
Ö®ËùÒÔÓзÖÇø¼¼Êõ£¬·ÖÇø¼¼ÊõÓõĺõϰ¿ÉÒÔÌá¸ßÐÔÄÜ£¬ÊÇÒòΪһ·½Ãæ·ÖÇø°ÑÒ»´ó¿éÊý¾Ý·Ö³ÉÁËnС¿é£¬ÕâÑù²éѯµÄʱºòºÜ¿ì¶¨Î»µ½Ä³Ò»Ð¡¿éÉÏ£¬ÔÚС¿éÖÐѰַҪ¿ìºÜ¶à£»ÁíÒ»·½ÃæCPU±È´ÅÅÌIO¿ìºÜ¶à±¶£¬¶øÓ²¼þÉÏÓÖÓжà¸ö´ÅÅÌ£¬»òÕßÊÇRAID£¨Á®¼Û´ÅÅÌÈßÓàÕóÁУ©£¬¿ÉÒÔÈÃÊý¾Ý¿âÇý¶¯CPUͬʱȥ¶Áд²»Í¬µÄ´ÅÅÌ£¬ÕâÑù²ÅÓпÉÄÜ¿ÉÒÔÌá¸ßЧÂÊ¡£
·ÖÇøÔÚÓÐЩʱºò²¢²»ÄÜÌá¸ß¶ÁдЧÂÊ£¬±ÈÈç˵ÎÒÃǾ­³£¿´µ½µÄ°´ÕÕÈÕÆÚ×Ö¶ÎÈ¥·ÖÇøMSDNÀý×Ó£¬Õ


Ïà¹ØÎÊ´ð£º

ÔÚ64λϵͳÉÏÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄÎÊÌâ

дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......

ÔõÑùÔ¶³Ì·ÃÎÊsqlserver 2005

ÎÒÏëÔÚÁíһ̨»úÆ÷ÉÏ·ÃÎʱ¾»úµÄsqlserver 2005 ¸ÃÔõôÅäÖá£Òª·ÃÎʵĻúÆ÷°²×°ÁËsqlserver 2005ÓõIJÙ×÷ϵͳÊÇwindows 2003 £¬Òª½øÐÐÔ¶³Ì·ÃÎʵĻúÆ÷Ò²°²×°ÁËsqlserver 2005 ÓõIJÙ×÷ϵͳÊÇwindows £Ø£Ð¡£¸ÃÔõôÅäÖòÅÄ ......

»ùÓÚsqlserver 2005µ¼³öÊý¾Ýµ½office 2007 Excel

´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ» ......

sqlserver ´¥·¢Æ÷ÎÊÌâ

ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£

CreateTRIGGER [Tri_UpdateLastSaveDate] ON  [dbo].[T]
  for UPDATE
AS
BEGIN ......

sqlserver µÄÊý¾Ý»¹Ô­

»¹Ô­µÄ±¨´íÐÅÏ¢:

System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)

Çë¸÷λ¸ßÊÖ°ïæ½â¾ö

»¹Ô­µÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ