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

ISA·À»ðǽ¿Í»§¶ËºÍSQLSERVER¿Í»§¶ËµÄÎÊÌâ

ÓÐÍâÀ´³ÌÐò°²×°»ùÓÚ.NET FRAMEWORK 3.5µÄÓ¦ÓóÌÐòÔÚÄÚÍøµÄPCÉÏ£¬ÐèҪͨ¹ýISA·À»ðǽ¿Í»§¶Ë¾­¹ý·þÎñÆ÷ÉϵÄISA2006 SP1·ÃÎÊÍâÍøµÄSQLSERVER2005Êý¾Ý¿â¡£
        °´ÕÕÒÔÍù¾­Ñ飬ÐèÒªÅäÖÃÒ»ÌõSQLSERVER2005·þÎñÆ÷ËùÔÚµÄIPµØÖ·µÄ³öÕ¾¹æÔò£¬²¢ÇÒ²¢²»ÐèÒªÉèÖÃÒ»Ìõ»ùÓÚÓòÃûµÄ¹æÔò¡£
        ¸ÃÓ¦ÓóÌÐòͨ¹ýÓòÃû·ÃÎÊÄ¿±êÊý¾Ý¿âÒ»ÇÐÕý³£¡£
        µ«ÎÒÔÚͬһ̨»úÆ÷ÉÏÓÃSQLSERVER 2005 MANAGEMENT STUDIOͬÑùÓÃÓòÃû·ÃÎÊÄ¿±êÊý¾Ý¿âÔòʧ°ÜÁË£º³¬Ê±Ê±¼äÒѵ½¡£ÔÚ²Ù×÷Íê³É֮ǰ³¬Ê±Ê±¼äÒѹý»ò·þÎñÆ÷δÏìÓ¦¡£ÓÚÊÇÎÒÓÃIPµØÖ··ÃÎÊÄ¿±êÊý¾Ý¿â£¬Ôò³É¹¦ÁË¡£
        ²é¿´ISA·þÎñÆ÷µÄÈÕÖ¾£¬¶àÁ˼¸Ìõ¼Ç¼£¬µäÐ͵ÄÒ»Ìõ¾ÍÊÇ0x80074e21 FWX_E_ABORTIVE_SHUTDOWN¡£
        ΪÁËÕÒµ½Ô­ÒòÎÒ¿ªÊ¼ÓÃVS2008×Ô¼ºÐ´³ÌÐò²âÊÔ£º
        sqlConn = new SqlConnection(@"Data Source=IPµØÖ·;Initial Catalog=***;User ID=***;Password=***");
        ³É¹¦!
        sqlConn = new SqlConnection(@"Data Source=ÓòÃû;Initial Catalog=***;User ID=***;Password=***");
         »¹ÊÇʧ°Ü!
        Îҷdz£À§»ó£¬ÎªÊ²Ã´ÍâÀ´µÄ³ÌÐòÓÃÓòÃû·ÃÎÊÄܹ»³É¹¦ÄØ¡£
        ÓÚÊÇ´ò¿ª¿ØÖÆÃæ°åÖеÄÊý¾ÝÔ´ (ODBC)£¬½¨Á¢Ò»¸öSQLSERVERµÄÁ¬½Ó£¬Õâ¸öʱºò·¢¾õÓÃIPµØÖ·Ò²²»Äܳɹ¦£¬Ææ¹ÖÖп´ÁËÏ¿ͻ§¶ËÅäÖÃÈ¥µôÁ˶¯Ì¬¾ö¶¨¶Ë¿Ú£¬Ö¸¶¨µÄ¶Ë¿ÚΪ1433£¬ÓÚÊÇÓÃIPÁ¬½Ó£¬³É¹¦ÁË¡£½Ó×ÅÓÃÓòÃû²âÊÔÒ²³É¹¦ÁË¡£ÁªÏëµ½ÔÚÕû¸ö²âÊÔ¹ý³ÉÖÐѯÎʹýÆäËûÈËÓÃPB×öµÄ³ÌÐòÊÇÄܳɹ¦·ÃÎÊÔ¶³ÌÊý¾Ý¿âµÄ£¬ÓÚÊÇ»ÐÈ»´óÎò£¬³É¹¦Óë²»³É¹¦Ô­ÒòÔÚÓëSQLSERVERµÄÇý¶¯ÉÏÃ棬³É¹¦µÄ¶¼ÊÇʹÓÃSQLOLEDBµÄÇý¶¯µÄ¡£
   
      ÓÚÊÇÔÚC#ÖÐдµ½£º
      OleDbConnection cnn = null;
  ¡¡string cnnstr="Provider=SQLOLEDB.1;Initial Catalog=***;Data Source=ÓòÃû,1433;User ID=***; Password=***";
       cnn = new


Ïà¹ØÎĵµ£º

sqlserverÒÆֲΪOracle±Ê¼Ç

Oracle±Ê¼Ç
l         ¹ØÓÚTRUNCº¯Êý
   SELECT
   RELATED_ID ,
      DOC_ID ,
      CAT_ID ,
      CAT_CODE ,
      RELEASE_DATE ,
&n ......

oracleÓësqlserverÖ´ÐÐcount(*)·µ»ØµÄ½á¹û¼æÈÝ

ÓÉÓÚÒÔÇ°¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1);    //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
  Object o = rs1.getObject(1);
 &nbs ......

¹ØÓÚoracleµ¼Èësqlserver´æÔÚµÄΨһË÷ÒýÎÊÌâ

ÎÒÔÚ°ÑoracleÊý¾Ýµ¼ÈësqlserverÖÐʱ£¬·¢ÏÖÔÚoracleÖÐ×ֶζ¨ÒåΪΨһË÷Òýʱ£¬²»Í¬¼Ç¼µÄ´Ë×Ö¶ÎÈç¹ûΪ¿Õ²»±»ÈÏΪÊÇÖظ´µÄ£¬µ«ÔÚsqlserverÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......

»ñÈ¡sqlserverÖÐÊý¾Ý¿âµ±Ç°Á¬½ÓÊý

ÈçºÎ²é¿´SQL SERVERÊý¾Ý¿âµ±Ç°Á¬½ÓÊý
1.ͨ¹ý¹ÜÀí¹¤¾ß
¿ªÊ¼->¹ÜÀí¹¤¾ß->ÐÔÄÜ£¨»òÕßÊÇÔËÐÐÀïÃæÊäÈë mmc£©È»ºóͨ¹ýÌí¼Ó¼ÆÊýÆ÷Ìí¼Ó SQL µÄ³£ÓÃͳ¼Æ È»ºóÔÚÏÂÃæÁгöµÄÏîÄ¿ÀïÃæÑ¡ÔñÓû§Á¬½Ó¾Í¿ÉÒÔʱʱ²éѯµ½Êý¾Ý¿âµÄÁ¬½ÓÊýÁË¡£²»¹ý´Ë·½·¨µÄ»°ÐèÒªÓзÃÎÊÄÇ̨¼ÆËã»úµÄȨÏÞ£¬¾ÍÊÇҪͨ¹ýWindowsÕË»§µÇ½½øÈ¥²Å¿ÉÒÔÌí¼Ó´Ë¼ÆÊ ......

SQLserver×Ö·û´®·Ö¸îº¯Êý

SQLserver×Ö·û´®·Ö¸îº¯Êý
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËظöÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
  @str varchar(1024),  --Òª·Ö¸îµÄ×Ö·û´®
  @split varchar(10)  --·Ö¸ô·ûº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ