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

Çë½Ìsql server 2008µÄ°²×°ÎÊÌâ

°²×°sql server 2008ÆóÒµ°æ³É¹¦ÁË£¬µ«ÊÇÔÚ°²×°Ê±Ñ¡ÔñÁË¡°sharepoint¼¯³É¡±Ä£Ê½£¬°²×°Á˱¨±í·þÎñÆ÷Ä£¿é£¬°²×°sql server 2008ǰÏȰ²×°ÁËIIS7£¬µ«»¹Ã»ÓÐ×°sharepoint£¬s²Ù×÷ϵͳÊÇwindows server 2008¡£
ÏÖÔÚµÄÎÊÌâÊÇ£¬ÏëÓñ¨±í·þÎñ£¬µ«·¢ÏÖÔÚ±¨±í·þÎñÅäÖùÜÀíÆ÷ÖÐÅäÖúó£¬ÄÜÁ¬½Óµ½Êý¾Ý¿â£¬µ«´ò¿ª±¨±í·þÎñÆ÷WEB·þÎñURLʱ³ö´í£º
´ò¿ªµÄURLΪ£ºhttp://»úÆ÷Ãû/ReportServer_MSSQLSERVER2008
´íÎóÌáʾÐÅϢΪ£º
ÅäÖòÎÊý SharePointIntegrated ±»ÉèÖÃΪ True£¬µ«ÎÞ·¨¼ÓÔØ Share Point ¶ÔÏóÄ£ÐÍ¡£´íÎóΪ: System.Reflection.TargetInvocationException: µ÷ÓõÄÄ¿±ê·¢ÉúÁËÒì³£¡£ ---> System.IO.FileNotFoundException: δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ÎļþÃû:¡°Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c¡± ÔÚ Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() ¾¯¸æ: ³ÌÐò¼¯°ó¶¨ÈÕÖ¾¼Ç¼±»¹Ø±Õ¡£ÒªÆôÓóÌÐò¼¯°ó¶¨Ê§°ÜÈÕÖ¾¼Ç¼£¬Ç뽫ע²á±íÖµ [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD)ÉèÖÃΪ 1¡£×¢Òâ: »áÓÐһЩÓë³ÌÐò¼¯°ó¶¨Ê§°ÜÈÕÖ¾¼Ç¼¹ØÁªµÄÐÔÄÜËðʧ¡£Òª¹Ø±Õ´Ë¹¦ÄÜ£¬ÇëÒÆ³ý×¢²á±íÖµ [HKLM\Software\Microsoft\Fusion!EnableLog]¡£ --- ÄÚ²¿Òì³£¶ÑÕ»¸ú×ٵĽáβ --- ÔÚ System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) ÔÚ System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) ÔÚ Sy


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ