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

InstallShield SQL Êý¾Ý¿â°²×°


À´Ô´:http://hi.baidu.com/czgblog/blog/item/3abd5aa911d51ff51f17a292.html
function OnFirstUIAfter()
     STRING szTitle, szMsg1, szMsg2, szOpt1, szOpt2;
     NUMBER bvOpt1, bvOpt2;
     NUMBER bShowUpdateServiceDlg;
     STRING szWaitText;
     STRING szServiceName;
     NUMBER svServiceState;
     STRING szMsde2000, szCmdLine,szStartServiceArgs;
begin
     // Èç¹û°²×°³ÌÐòÒԓά»¤”ģʽÆô¶¯
     if (MAINTENANCE) then
         goto EndProcess;
     endif;
     // ¼ì²éϵͳÊÇ·ñ°²×°ÁË MSDE 2000 SP4
     szWaitText = "ÕýÔÚ¼ì²éϵͳÊÇ·ñ°²×°ÁË MSDE2000 SP4 …….";
     SdShowMsg( szWaitText, TRUE);    
     szServiceName = "MSSQLSERVER";
     if(ServiceGetServiceState(szServiceName, svServiceState) < ISERR_SUCCESS) then
         // ûÓа²×° MSDE£¬×ª°²×°´¦Àí
         goto InstallMSDE;    
     endif;
     goto StartMSDE;
InstallMSDE:   // °²×°Êý¾Ý¿â·þÎñ  
     szWaitText = "ÕýÔÚ°²×° MSDE2000 SP4¡£Õâ¸ö¹ý³ÌÐèÒª¼¸·ÖÖÓ£¬ÇëÉÔµÈ";
     SdShowMsg(szWaitText, TRUE);     
     szMsde2000 = SRCDIR ^ "MSDE" ^ "setup.exe";
     // ½« MSDE 2000 SP4 °²×°µ½ÏµÍ³ Program File Ŀ¼ÏÂ
     szCmdLine = "TARGETDIR="" + PROGRAMFILES + "" /q";
     if(LaunchAppAndWaitszMsde2000, szCmdLine, LAAW_OPTION_WAIT|LAAW_OPTION_MAXIMIZED) < 0 ) then
         Mes


Ïà¹ØÎĵµ£º

Oracle ²éѯ²¢É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä


²éѯ¼°É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)
 
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......

SQL´æ´¢¹ý³Ìѧϰ


¡¡¡¡±¾ÎÄ´ÓSQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㣬Óï·¨£¬´´½¨¼¼ÇÉ£¬µ÷Óõȶ෽Ãæ½éÉÜÁËSQL´æ´¢¹ý³Ì¡£
¡¡¡¡Ò»¡¢SQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㼰Óï·¨
¡¡¡¡¡¡¶¨Ò壺½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ÉÃüÁî¡ ......

SQL×¢Èë½Ì³ÌÖ®½ø½×ƪ

ÔÚÈëÃÅƪ£¬ÎÒÃÇѧ»áÁˣӣѣÌ×¢ÈëµÄÅжϷ½·¨£¬µ«ÕæÕýÒªÄõ½ÍøÕ¾µÄ±£ÃÜÄÚÈÝ£¬ÊÇÔ¶Ô¶²»¹»µÄ¡£½ÓÏÂÀ´£¬ÎÒÃǾͼÌÐøѧϰÈçºÎ´ÓÊý¾Ý¿âÖлñÈ¡ÏëÒª»ñµÃµÄÄÚÈÝ£¬Ê×ÏÈ£¬ÎÒÃÇÏÈ¿´¿´£Ó£Ñ£Ì×¢ÈëµÄÒ»°ã²½Ö裺
µÚÒ»½Ú¡¢£Ó£Ñ£Ì×¢ÈëµÄÒ»°ã²½Öè
¡¡¡¡Ê×ÏÈ£¬Åжϻ·¾³£¬Ñ°ÕÒ×¢Èëµã£¬ÅжÏÊý¾Ý¿âÀàÐÍ£¬ÕâÔÚÈëÃÅƪÒѾ­½²¹ýÁË¡£
¡¡¡¡Æä´Î£¬¸ù¾Ý×¢Èë ......

ÐÞ¸´SQL Server Enterprise Manager.MSC

       ½ñÌì´ò¿ªÆóÒµ¹ÜÀíÆ÷µÄʱºòÌáʾ“¹ØÓÚMMC²»ÄÜ´ò¿ªÎļþC:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC¿ÉÄÜÊÇÓÉÓÚÎļþ²»´æÔÚ£¬²»ÊÇÒ»¸öMMC¿ØÖÆ̨£¬»òÕßÓúóÀ´µÄMMC°æ±¾´´½¨¡£Ò²¿ÉÄÜÄãûÓзÃÎÊ´ËÎļþµÄ×㹻ȨÏÞ”£¬googleÖ®£¬·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ