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

¡¶Èí¼þ¿ª·¢ÐÔÄÜÓÅ»¯ÏµÁС·Ö®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


Ïà¹ØÎĵµ£º

Êý¾Ý¿âsqlµÄÌØÊâ×Ö·û£º

Êý¾Ý¿âsqlµÄÌØÊâ×Ö·û£º
1£©µ¥ÒýºÅ’£ºÀýÈçstring a = “this is marry’s book.”;
             Ê¹ÓÃinsertʱ¾Í»á³ö´í¡£
             ½â¾ö£ºa= a.Replace("'","' ......

sql serverµÄËæ»úº¯ÊýnewID()ºÍRAND()¡¡¡¡

sql serverµÄËæ»úº¯ÊýnewID()ºÍRAND()¡¡¡¡
¡¡¡¡SELECT * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--Ëæ»úÅÅÐò
¡¡¡¡SELECT TOP 10 * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--´ÓOrders±íÖÐËæ»úÈ¡³ö10Ìõ¼Ç¼¡¡¡¡
¡¡¡¡Ê¾Àý¡¡¡¡
¡¡¡¡A.¶Ô±äÁ¿Ê¹Óà NEWID º¯Êý
¡¡¡¡ÒÔÏÂʾÀýʹÓà NEWID() ¶ÔÉùÃ÷Ϊ uniq ......

½â¾ö£ºSQL Server·þÎñÎÞ·¨Æô¶¯

Æô¶¯SQL Server (SQLEXPRESS)·þÎñʱÌáʾ´íÎó£¬Ê¼þ²é¿´Æ÷ÏÔʾÒÔÏÂÐÅÏ¢£¨ID 9003£©£º
´«µÝ¸øÊý¾Ý¿â 'master' ÖеÄÈÕ־ɨÃè²Ù×÷µÄÈÕ־ɨÃèºÅ (276:232:1) ÎÞЧ¡£´Ë´íÎó¿ÉÄÜָʾÊý¾ÝË𻵣¬»òÕßÈÕÖ¾Îļþ(.ldf)ÓëÊý¾ÝÎļþ(.mdf)²»Æ¥Åä¡£Èç¹û´Ë´íÎóÊÇÔÚ¸´ÖÆÆÚ¼ä³öÏֵģ¬ÇëÖØÐ´´½¨·¢²¼¡£·ñÔò£¬Èç¹û¸ÃÎÊÌâµ¼ÖÂÆô¶¯ÆÚ¼ä³ö´í£¬Çë´Ó± ......

ʹÓÃVB½«Excelµ¼Èëµ½SqlÖÐ

ʹÓÃVB°ÑExcelµ¼Èëµ½SqlÊý¾Ý¿âÖУ¬ÆäʵÓм¸ÖÖ·½·¨¡£
ÏÂÃæÎÒ½éÉܵÄÕâÖÖ·½·¨£¬½ÏΪ¼òµ¥¡£
ÆäʵÕâÖÖ·½·¨µÄ»°£¬ÊÇÖ±½ÓʹÓÃT-SQL²Ù×÷µÄ£¬Òò´Ë£¬µ½ÁËVBÀïÃæ£¬Ö±½ÓeccuteÕâ¸ö´úÂë¾ÍOKÁ˵ġ£
-----------------------------------------------------ÏÂÃæÊÇÔÚT-sqlÖеÄÓï¾ä
if object_id('NewTable') is not null/*ÅжϱíNewTabl ......

EXCELÉú³ÉSQL½¨±í´æ´¢¹ý³ÌµÄVBA½Å±¾

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ