¡¶Èí¼þ¿ª·¢ÐÔÄÜÓÅ»¯ÏµÁС·Ö®SqlÐÔÄÜÓÅ»¯(¶þ)
Ò»¡¢SQLƴд½¨Òé 1¡¢²éѯʱ²»·µ»Ø²»ÐèÒªµÄÐС¢ÁÐ ÒµÎñ´úÂëÒª¸ù¾Ýʵ¼ÊÇé¿ö¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý£¬×îС»¯½á¹û¼¯£¬ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØÊ¹ÓÃͨÅä·ûÈ磺select * from table1Óï¾ä£¬ÒªÓõ½¼¸ÁоÍÑ¡Ôñ¼¸ÁУ¬È磺select col1,col2 from table1;ÔÚ¿ÉÄܵÄÇé¿öϾ¡Á¿ÏÞÖÆ½á¹û¼¯ÐÐÊýÈ磺select top 100 col1,col2,col3 from talbe2,ÒòΪijЩÇé¿öÏÂÓû§ÊDz»ÐèÒªÄÇô¶àµÄÊý¾ÝµÄ¡£ 2¡¢ºÏÀíʹÓÃEXISTS, NOT EXISTS×Ö¾ä ÈçÏÂËùʾ£º SELECT SUM(T1.C1) from T1 WHERE ((SELECT COUNT(*) from T2 WHERE T2.C2=T1.C2)>0) SELECT SUM(T1.C1) from T1 WHERE EXISTS(SELECT * from T2 WHERE T2.C2=T1.C2) Á½ÖÖ²úÉúÏàͬµÄ½á¹û£¬µ«ÊǺóÕßµÄЧÂÊÏÔȻҪ¸ß¹ýÓÚǰÕß¡£ÒøÐкóÕß²»»á²úÉú´óÁ¿Ëø¶¨µÄ±íɨÃè»òÊÇË÷ÒýɨÃè¡£ ¾³£ÐèҪЩһ¸öT_SQLLÓï¾ä±È½ÏÒ»¸ö¸¸½á¹û¼¯ºÍ×Ó½á¹û¼¯£¬´Ó¶øÕÒµ½ÊÇ·ñ´æÔÚÔÚ¸¸½á¹û¼¯ÖÐÓжøÔÚ×Ó½á¹û¼¯ÖÐØ¿嘢µÄ¼Ç¼£¬È磺 SELECT _a.hdr_key from hdr_tb1 a -----------tb1 a ±íʾtb1ÓñðÃûa´úÌæ WHERE NOT EXISTS (SELECT * from dt1_tb1 b WHERE a.hdr_key = b.hdr_key) SELECT _a.hdr_key from hdr_tb1 a -----------tb1 a ±íʾtb1ÓñðÃûa´úÌæ LEFT JION dt1_tb1 b ON a.hdr_key = b.hdr_key WHERE b.hdr_key IS NULL SELECT hdr_key from hdr_tb1 WHERE hdr_key NOT IN (SELECT hdr_key from dt1_tb1) ÈýÖÖд·¨¶¼¿ÉÒԵõ½Í¬ÑùµÄ½á¹û¼¯£¬µ«ÊÇЧÂÊÊÇÒÀ´Î½µµÍ 3¡¢³ä·ÖÀûÓÃÁ¬½ÓÌõ¼þ ÔÚijÖÖÇé¿öÏ£¬Á½¸ö±íÖ®¼ä¿ÉÄܲ»Ö¹Ò»¸öµÄÁ¬½ÓÌõ¼þ£¬ÕâʱÔÚwhere ×Ö¾äÖн«Á½âÌõ¼þÍêÕûµÄдÉÏ£¬ÓпÉÄÜ´ó´óÌá¸ß²éѯËÙ¶È¡£ Àý£º a)¡¢SELECT SUM(A.AMOUNT) from ACCOUNT A left j
Ïà¹ØÎĵµ£º
Ò»¡¢Êý¾Ý¿â´æ´¢¸ÅÊö
1¡¢Êý¾ÝÎļþÀàÐÍ
· Primary data files:ÿ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öµ¥¶ÀµÄÖ÷ÒªÊý¾ÝÎļþ£¬Ä¬ÈÏÒÔ.mdfÀ©Õ¹Ãû¡£Ö÷ÒªÊý¾ÝÎļþ²»½ö°üº¬Êý¾ÝÐÅÏ¢£¬»¹°üº¬Óë¸ÃÊý¾Ý¿â½á¹¹Ïà¹ØµÄÐÅÏ¢¡£´´½¨Êý¾Ý¿âʱ£¬Êý¾Ý¿â½á¹¹Ïà¹ØÐÅÏ¢²»½ö´æÔÚÓÚmasterÊý¾Ý¿âÖУ¬Í¬Ê ......
Èë Êƪ
Èç¹ûÄãÒÔǰûÊÔ¹ýSQL×¢ÈëµÄ»°£¬ÄÇôµÚÒ»²½ÏȰÑIE²Ëµ¥=>¹¤¾ß=>InternetÑ¡Ïî=>¸ß¼¶=>ÏÔʾÓѺà HTTP ´íÎóÐÅÏ¢Ç°ÃæµÄ¹´È¥µô¡£·ñÔò£¬²»ÂÛ·þÎñÆ÷·µ»ØÊ²Ã´´íÎó£¬IE¶¼Ö»ÏÔʾΪHTTP 500·þÎñÆ÷´íÎ󣬲»ÄÜ»ñµÃ¸ü¶àµÄÌáʾÐÅÏ¢¡£
µÚÒ»½Ú¡¢SQL×¢ÈëÔÀí
ÒÔÏÂÎÒÃÇ´ÓÒ»¸öÍøÕ¾www.19cn.com¿ªÊ¼£¨×¢£º±¾ÎÄ·¢±íǰÒÑÕ÷µ ......
¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = Data.Connstr();
Conn.Open();
......
*
ÌṩÁ½ÖÖ°æ±¾µÄOutLookÓʼþ·¢ËÍ·½Ê½
ÓÐÒÉÎÊÁªÏµ×÷Õß: zlp321001@hotmail.com
*/
A:ÀûÓÃOutLook2003·¢ËÍÓʼþ
----------------------------------------------------------------------
/
*²âÊÔ»·¾³: windowx Xp
OutLook: OutLook 2003
²âÊԵĵç×ÓÓʼþ: zlp321001@126.com
/
µÚÒ»²½Ö裺½¨ÅäÖÃÎļþ
......
HO~HO~EXCELÉú³ÉSQL½¨±í´æ´¢¹ý³ÌµÄVBA½Å±¾^_^ÔÞÒ»ÏÂ
2007-12-11 10:39
'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ È«¾Ö±äÁ¿¶¨Òå
Const MAX_COLUMN_NUM = 50
Dim stOutputPath As String
Dim stOutputFile As String
Dim stDBName As String
Dim stUserName As String
Dim stUserPasswd As ......