Çë½Ì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
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
±íA
Sup_code st_sup_code buy_code buy_code1
1001 400 &nbs ......
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN
¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª
ÐÕÃû ¿ÆÄ¿ ³É¼¨
ÕÅÈý Ó¢Óï 90
ÀîËÄ Ó¢Óï&nb ......