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

SQLÓï¾äÓÅ»¯

¶ÔͬһÕÅ±í½øÐÐÁ½ÖÖ·½Ê½²éѯ£¨½á¹û¼¯Ïàͬ£©£º
case1 ²éѯÌõ¼þ:°üÀ¨¼ÆËã»úÃû£¬êdzƣ¬Ìí¼Óʱ¼äµÈµÈһЩÏÞÖÆÌõ¼þ×ֶΡ£¶øÇÒÐèÁª±í²éѯ±ðµÄ±í
²éѯÊý¾ÝÁ¿£º             100Íò       200Íò
µ¥´¿Ö´ÐÐSQLÓï¾äËùÐèʱ¼ä£º31ºÁÃë       31ºÁÃë
Ñ­»·±éÀúÊý¾Ý¼¯ËùÐèʱ¼ä£º 57Ãë        1·Ö50Ãë
case 2²éѯÌõ¼þ£ºÎÞ
select * from ¡¾±í¡¿
²éѯÊý¾ÝÁ¿£º             100Íò        200Íò
µ¥´¿Ö´ÐÐSQLÓï¾äËùÐèʱ¼ä£º31ºÁÃë      31ºÁÃë
Ñ­»·±éÀúÊý¾Ý¼¯ËùÐèʱ¼ä£º 20Ãë        40Ãë
×¢ÒâÏÂÑ­»·±éÀúÊý¾Ý¼¯Ê±¼ä£¨×ÝÏò100ÍòµÄ£¬»òÕß200ÍòµÄ¶¼ÐУ©£¬²éѯÌõ¼þ²»Ò»Ñù£¬¾¡¹Ü×îÖÕ²éѯÊý¾ÝÁ¿ÊÇÒ»ÑùµÄ£¬µ«ÊDZéÀúʱ¼ä²î±ðºÜ´ó¡£
ÎªÊ²Ã´ÄØ£¿
¿É²»¿ÉÒÔÕâôÀí½â£¬SQLÓï¾äÔ½¸´ÔÓ£¨»òÕß˵ÓÅ»¯³Ì¶ÈûÄÇô¸ß£©£¬Ó°ÏìµÄ²»ÊÇSQL±¾ÉíµÄÖ´ÐУ¬¶øÊÇÊý¾ÝµÄÌáÈ¡ÄØ£¿


Ïà¹ØÎĵµ£º

ʹÓÃSQL Serverµ¼Èë/µ¼³öExcel

ʹÓÃSQL Serverµ¼Èë/µ¼³öExcel,°üº¬²¿·Ö´íÎóÐÅÏ¢´¦Àí·½·¨;
²Ù×÷ÊÖ¼Ç,Áô´Ë±¸²é
/*
µ¼Èë
*/
--´íÎóÐÅÏ¢ÈçÏÂʱ£º
--Msg 15281, Level 16, State 1, Line 2
--SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as ......

SQL Server 2005 ÓÃSQL ServerµÄsaÎÞ·¨µÇ¼

ʹÓÃSQL ServerÉí·ÝÑéÖ¤µÇ¼ʱ±¨´í£º
ÎÞ·¨Á¬½Óµ½.\SQLEXPRESS.
Additional information:
Óû§'sa'µÇ¼ʧ°Ü¡£¸ÃÓû§Óë¿ÉÐÅSQL Server Á¬½ÓÎÞ¹ØÁª¡£(microsoft SQL Server,Error:18452£©)
------------------
ÏÂÃæÊÇÓ³Éäʱ±¨µÄ´í£º
´´½¨¶ÔÓÚÓû§“sa”ʧ°Ü¡££¨microsoft.sqlServer.express.smo£©
Additional ......

SQL Server´æ´¢¹ý³Ì±àдºÍÓÅ»¯´ëÊ©

Ò»¡¢Êʺ϶ÁÕß¶ÔÏó£ºÊý¾Ý¿â¿ª·¢³ÌÐòÔ±£¬Êý¾Ý¿âµÄÊý¾ÝÁ¿ºÜ¶à£¬Éæ¼°µ½¶ÔSP£¨´æ´¢¹ý³Ì£©µÄÓÅ»¯µÄÏîÄ¿¿ª·¢ÈËÔ±£¬¶ÔÊý¾Ý¿âÓÐŨºñÐËȤµÄÈË¡£ ¡¡
¶þ¡¢½éÉÜ£ºÔÚÊý¾Ý¿âµÄ¿ª·¢¹ý³ÌÖУ¬¾­³£»áÓöµ½¸´ÔÓµÄÒµÎñÂß¼­ºÍ¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬Õâ¸öʱºò¾Í»áÓÃSPÀ´·â×°Êý¾Ý¿â²Ù×÷¡£Èç¹ûÏîÄ¿µÄSP½Ï¶à£¬ÊéдÓÖûÓÐÒ»¶¨µÄ¹æ·¶£¬½«»áÓ°ÏìÒÔºóµÄϵͳά»¤ ......

sql¹ØÓÚbetweenµÄÓ÷¨¸Ä½ø

×î½üÓõ½ÈÕÆÚ·¶Î§µÄ²éѯ£¬Óõ½ÁËbetween£¬µ«ÊÇ·¢ÏÖÈç¹ûÈÕÆÚ´øÊ±¼äµÄ»°£¬BETWEEN '2010-1-4' AND 
       '2010-1-4'ÕâÑùµÄÓï¾äÊDz鲻µ½Êý¾ÝµÄ£¬ºóÀ´Ïëµ½ÁËÒ»ÖָĽø·½·¨£¬¹©´ó¼Ò²Î¿¼¡£
ÈçÏ£º
BETWEEN '2010-1-4' AND DATEADD(day, 1, '2010-1-4')
ÓÃÁËDATEADDÒÔºó£¬Ð§¹ûºÜ²»´í ......

SQL CLR ¼¯³É

Ò»¡¢ÅäÖà SQL Server£¬Ê¹Ö®ÔÊÐí CLR ¼¯³É:
¡¡¡¡1.µ¥»÷“¿ªÊ¼”°´Å¥£¬ÒÀ´ÎÖ¸Ïò“ËùÓгÌÐò”¡¢Microsoft SQL Server 2005 ºÍ“ÅäÖù¤¾ß”£¬È»ºóµ¥»÷“ÍâΧӦÓÃÅäÖÃÆ÷”¡£
¡¡¡¡2.ÔÚ SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¹¤¾ßÖУ¬µ¥»÷“¹¦ÄܵÄÍâΧӦÓÃÅäÖÃÆ÷”¡£
¡¡¡¡3.Ñ¡ÔñÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ