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Àý×Ó£¬Õ
Ïà¹ØÎÊ´ð£º
дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......
ÎÒÏëÔÚÁíһ̨»úÆ÷ÉÏ·ÃÎʱ¾»úµÄsqlserver 2005 ¸ÃÔõôÅäÖá£Òª·ÃÎʵĻúÆ÷°²×°ÁËsqlserver 2005ÓõIJÙ×÷ϵͳÊÇwindows 2003 £¬Òª½øÐÐÔ¶³Ì·ÃÎʵĻúÆ÷Ò²°²×°ÁËsqlserver 2005 ÓõIJÙ×÷ϵͳÊÇwindows £Ø£Ð¡£¸ÃÔõôÅäÖòÅÄ ......
´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ» ......
ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£
CreateTRIGGER [Tri_UpdateLastSaveDate] ON [dbo].[T]
for UPDATE
AS
BEGIN ......
»¹ÔµÄ±¨´íÐÅÏ¢:
System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)
Çë¸÷λ¸ßÊÖ°ïæ½â¾ö
»¹ÔµÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......