SQL SERVER ¾¿¾¹Ê²Ã´Ê±ºòдÈÕÖ¾£¿
×òÌì¿´µ½ÍøÉÏÓÐÒ»¸ö¹ØÓÚSQL SERVER ¿Î¼þ£¬±ãËæÊÖÏÂÔØÁËÏÂÀ´¿´¿´Ö÷Òª½²ÁËЩʲôÄÚÈÝ£¬ÓÚÊÇ¿´µ½ÁËÏÂÃæÁ½¸öPPTÒ³Ãæ
ÓÉÓÚµÚÒ»ÕÅPPTÉϵÄÄÚÈݲ»Ì«×¼È·£¨ÈÕÖ¾ÎļþÖÐûÓГÈÕÖ¾Ò³”µÄ¸ÅÄֻÓÐVLFµÄ¸ÅÄ¿ÉÄÜÊÇÎÒÃǶԓÊý¾ÝÒ³”µÄ¸ÅÄîÌ«Éî¿ÌÁË£¬Òò´ËŪÁËÒÔ“ÈÕÖ¾Ò³”µÄ¸ÅÄî³öÀ´£¬¶øPPTÖÐ˵ÏȸüиßËÙ»º³åÇøÖеÄÊý¾ÝÒ³£¬È»ºó½«ÊÂÎñÈÕ־дÈëµ½“ÈÕÖ¾Ò³”£¬ºÜÈÝÒ×ÈÃÈËÀí½â³ÉÏȸü¸Ä¸ßËÙ»º³åÇø£¬È»ºó½«ÈÕ־дÈëµ½´ÅÅÌÉϵēÈÕÖ¾Ò³”£©,ÔÙ¼ÓÉÏÎÒ¿´PPTʱ±È½Ï"àñàð"(Ö»¿´µ½Ç°Ò»ÕÅPPT,ûÓÐÍùºó·Á½Ï¿´ºóÃæÒ»ÕÅPPT).Òò´ËÎÒ¾õµÃPPTµÄ×÷ÕßÔÚÈÕÖ¾µÄдÈë˳ÐòÉÏÓÐÎÊÌâ.Ë÷ÐÔ²éÁËÒ»ÏÂ×ÊÁÏ,È»ºó±È½ÏÉîÈëµÄ˼¿¼ÁËÈÕÖ¾µÄдÈë˳ÐòÎÊÌâ,ͬʱҲ¾ÀÕýÁËһЩ×Ô¼ºÒÔÍùµÄ²»ÕýÈ·Àí½â.
¸ÃÎÄÖ÷Òª°üº¬ÒÔÏÂÄÚÈÝ:
1.SQL SERRVER ÈÕÖ¾¹ÜÀíÆ÷µÄ´óÖ¹¤×÷ÄÚÈÝÓëÔÀí.
2.ʵÀý̽¾¿SQL SERVER ÊÂÎñÈÕÖ¾µÄ²úÉúÓëдÈë´ÅÅÌ´ÅÅÌ.
3.һЩÆäËüµÄÏà¹Ø˼¿¼.
µÚÒ»²¿·Ö:SQL SERVER ÈÕÖ¾¹ÜÀíÆ÷µÄ´óÖ¹¤×÷ÔÀí.
ÈÕÖ¾¹ÜÀíÆ÷³Ðµ£×ÅÊÂÎñÈÕÖ¾µÄ±àÅÅÓëдÈ빤×÷¡£Ëüά»¤×ÅÒ»¸ö»ò¶à¸ö±»³Æ֮Ϊ“ÈÕÖ¾»º´æ”µÄÁ¬ÐøµÄרÓÃÄÚ´æÇøÓò¡£ÓÉÓÚSQL SERVER ÊÂÎñÈÕÖ¾±ØÐë°´ÕÕÒ»¶¨µÄ¸ñʽдÈëµ½ÈÕÖ¾ÎļþÖУ¬Òò´ËÈÕÖ¾»º´æÖеŦÄÜÖ®Ò»¾ÍÊÇÓÃÀ´±àÅÅÈÕÖ¾µÄ¸ñʽ¡£¶øµ±Ò»¸öÈÕÖ¾»º´æÇøÓò±»Õ¼ÂúµÄʱºò£¬»¹ÓÐÒ»¸ö»ò¶à¸öÈÕÖ¾»º´æÇøÓò¿ÉÒÔ±»ÓÃÀ´±£´æвúÉúµÄÈÕÖ¾¼Ç¼¡£
Æä´Î£¬ÈÕÖ¾¹ÜÀíÆ÷ά»¤×ÅÁ½¸öÈÕÖ¾»º´æ¶ÓÁУ¬Ò»¸öflushQueue,ÁíÒ»¸öÊÇfreeQueue¡£ÆäÖÐflushQueue°üº¬µÄÊǵȴý±»Ë¢Ðµ½ÈÕÖ¾Îļþ£¨ÎïÀí´ÅÅÌ£©µÄÈÕÖ¾»º´æ£»freeQueue°üº¬µÄÊÇÒѾ±»Ë¢Ð²¢ÇÒ¿ÉÒÔ±»ÔÙ´ÎʹÓõÄÈÕÖ¾»º´æ¡£
¶øÈÕÖ¾µÄˢй¤×÷Ö÷ÒªÒ»¸ö±»³Æ֮Ϊ“ÈÕÖ¾±àдÆ÷”µÄÏß³ÌÀ´¸ºÔð£¬Ëü½«ÒÀ´Î±éÀú flushQueue£¬Ò»´Î½ö½«Ò»¸öµ±Ç°µÄÈÕÖ¾»º´æÖеÄÄÚÈÝдÈëµ½´ÅÅÌÉÏ¡£
¶øÈÕÖ¾±àдÆ÷µÄˢй¤×÷ÓÉʲôÀ´´¥·¢ÄØ£¿µ±Ò»¸öÊÂÎñ±»Ìύʱ»òÕßÈÕÖ¾»º´æ±»Õ¼Âúʱ£¬µ±Ç°µÄÈÕÖ¾»º´æ¾Í±»·ÅÈëflushQueue£¬ÈÕÖ¾±àдÆ÷¾Í±ØÐ뿪ʼ¹¤×÷¡£ÈÕÖ¾±àдÆ÷µÄ¹¤×÷Íê³Éºó£¬ ÈÕÖ¾¹ÜÀíÆ÷½«»áÊÕµ½Ò»¸öдÈë³É¹¦µÄÐźţ¬½ø¶ø¼¤»îËùÓÐÕýÔڵȴýÈÕÖ¾»º´æˢеÄËùÓнø³Ì£¬ÒÔ¼Ì
Ïà¹ØÎĵµ£º
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
--ÇóÌõsqlÓï¾ä£º
-- ÒªÇó£º1.°´ÕÕGroup_OutDate×Ö¶ÎÅÅÐò £¬µÃµ½Ç°5Ìõ¼Ç¼
-- 2.Group_Name×ֶεÄÖµ²»ÄÜÖظ´
SELECT TOP 5 * from
( SELECT DISTINCT Group_Name ,
(SELECT TOP 1 Group_ID from AA_Sell_Group AS b WHERE b.Gro ......
Use equality first.
ʹÓõÈÁ¬½Ó
Use range operators only where equality does not apply.
Ö»ÓÐÔÚµÈÁ¬½Ó²»¿ÉÓõÄÇé¿öÏÂÊÂÓÉÇø¼äÁ¬½Ó
Avoid use of negatives in the form of !=
or NOT.
±ÜÃâʹÓà £¡= »òÕß not
Avoid LIKE pattern matching.
±ÜÃâʹÓà LIKEÆ¥Åä
Try to retrieve specific rows and in small n ......