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

ÓÃRDA ·½Ê½Í¬²½SQLCE ÓëSQL SERVER Êý¾Ý¿â

´úÂëÊÇÍøÉϸãµÄ£¬Ó¦¸ÃûÎÊÌâ¡£×îºóÔËÐеÄʱºò´íÎóÌáʾΪ¿Õ£¬µ«ÊÇÌáʾpullÀïÓдíµÄ£¬issÅäÖÃÊÇÕýÈ·µÄ¡£ÎÒ¹À¼ÆÊÇÎÒÔÚµçÄÔÉÏÊý¾Ý¿â½¨´íÁË£¬ÓÐûÓÐÈËÅöµ½¹ýÕâÎÊÌâ
´ò¿ªÆóÒµ¹ÜÀíÆ÷,´´½¨Ò»¸öÐÂÊý¾Ý¿â,ÃûΪ¡°ABC¡±,ÔÚ¡°ABC¡±Ï´´½¨Ò»¸öÊý¾Ý±í,ÕâÀïµÄÊý¾Ý¿âÊÇʲôÀàÐ͵ÄÊý¾Ý¿â£¿

            if (File.Exists(dbPathName))
                File.Delete(dbPathName);
            string strCon = "Data Source =" + dbPathName + ";Password=";
            SqlCeEngine engine = new SqlCeEngine(strCon);
            engine.CreateDatabase();
            engine.Dispose();
            SqlCeRemoteDataAccess rda = null;
            //SQL Server ËùÔÚµÄÖ÷»úµÄIP
            string remoteIP = "172.16.108.61";
            //SQL Server ÖеÄÊý¾Ý¿â,ÃûΪABC
            string remoteDB = "abc";
            // Êý¾Ý¿âABC µÄÓû§ºÍÃÜÂë
            string user = "sa";
            string pwd = "123456";
          &nbs


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

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Îļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ