Çë½Ì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
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
table1
Ãû³Æ Èë¿âÊý
CT»ú 3
CT»ú 5
X¹â»ú 4 ......