Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£
ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû" È»ºóÑ¡Ôñ"н¨µÇ¼Ãû"
È»ºóµ¯³ö¸ö½çÃæ¡£ ÎÒÔٵǽÃûÄǸö¿òдÁËabcdef È»ºóÑ¡ÔñS ......
ÏÖÔÚÓÐÒ»ÕŲ¿Ãűí(SYS_DEPT)½á¹¹ÈçÏ£º
DEPT_ID(²¿ÃÅID) DEPT_NAME(²¿ÃÅÃû³Æ) DEPT_PARENT_ID(²¿ÃŸ¸½ÚµãÃû³Æ)
ҪʵÏÖµÄÄÚÈÝΪ£º
¸ù¾ÝÉÏÃæÕâÕŲ¿ÃűíÖеÄÈÎÒâÒ»¸öDEPT_ID(²¿ÃÅID)²éѯ³ö¸Ã²¿ÃÅÒÔ¼°¸Ã²¿ÃÅÏÂËùÓеIJ¿ÃÅÐÅÏ¢¡£
È磺
1 ²¿ÃÅÃû³Æ1 0
......
sqlserver ÓÃbcp³éÈ¡Êý¾Ý¡£db2ºÍoracle·Ö±ðÓÃʲôÃüÁîʵÏÖÓësqlserverͬÑùµÄ¹¦ÄÜ¡£
my @proglist =("bcp","$database.bill.$group[$i]","out","$dir\\$currentTime\\$group[$i].txt","-c","-t\!\^","-r\ \n","-R","-U$user" ......
ÎÒµÄÓʼþ³ÌÐòÊǶÁȡһ¸öhtmlÎļþ×öÓʼþÄ£°åÀ´·¢Ë͵쬵«ÊÇÎÒÏë¶ÔÕâ¸öÄ£°åÄÚÈÝ×÷ÁÙʱ´¦Àí£¬±ÈÈç˵£¬·¢¸øA¾ÍÔÚ̧ͷдÉÏAµÄÃû×Ö£¬ÎÒÏëÖªµÀÓÐûÓÐʲô°ì·¨¿ÉÒÔ´¦Àí£¿×îºÃÊÇÄÜÔÚÄ£°å¶Á½øÀ´Ö®ºó×ö´¦Àí£¬¶ø²»ÊÇÖ±½ÓÐÞ¸ÄÄ£°å¡£ÀýÈç˵£¬ÔÚÕâ¸öÄ£°åÀïÃæÐ´Ò»¸ö±äÁ¿ÄÜÔÚ³ÌÐòÖиøÕâ¸ö±äÁ¿¸³Öµ¡£ÒòΪTIdMessageÓÐÒ»¸öMSGIDµÄÊôÐÔ£¬Õâ¸öÃ²Ë ......
ÎÒÒªÁ¬Ò»¸öÊý¾Ý¿â£¬ÓÃÁËADOConnection¡¢ADODataSet¡¢DBGrid×é¼þ£¬Ç°Á½¸ö×é¼þÒѾ¹ØÁªÉÏÀ´£¬µ«ÊÇDBGrid¾ÍÊÇÏÔʾ²»³öÁÐÃûÀ´£¬DBGridºÍADODataSetÔõô°ó¶¨°¡£¿
datasource.dataset := ADODataSet
ÓÐÁË£¬Ð»Ð»
ÔÙÎÊÎÊ£¬ADOConnectionÁ¬½ÓoracleÔõôÉèÖã¿
oracle¿Í»§¶ËÒѾÓÐÁË¡£
......
°´²»Í¬µÄÈË£¬²»Í¬µÄȨÏ޷ֱ𿪡£
·½·¨Ì«¶àÁË¡¡ÔÚÓû§µÄÐÅÏ¢Öжà¸ö²Ëµ¥ÁÐ±í¡£»òÕß°´È¨ÏÞ±ê¼ÇÔڲ˵¥µÄtagÀïÃæ£¬È»ºóÓû§È¨ÏÞÓëÕâ¸öȨÏÞ×ö¶Ô±È¡£Ì«¶àÁË¡¡
Ò»°ã¿ØÖÆaction
ÓýÇÉ«¿ØÖÆ
ÎÒÏÖÔÚÕýºÃÔÚ×öÕâ·½ÃæµÄ¶«Î÷£¬½²½²ÎÒµÄ˼·£º
ȨÏÞ¹ÜÀíÉæ¼°µ½µÄÄ£¿é
1.ÈËÔ±¹ÜÀí£¬T_Person±í £¨id,name,...£©
2.½ÇÉ«¹ ......