sqlserver ɾ³ýÖØ¸´¼Ç¼ÁôÒ»Ìõ
sqlserver ɾ³ýÖØ¸´¼Ç¼ÁôÒ»Ìõ£¬¼´ÓÐÖØ¸´×Ö¶ÎÖ»Òª±£ÁôÒ»Ìõ¼Ç¼ÆäÓàµÄ¶¼É¾³ý¡£
»áÓÐÈËÌùµÄ¡£¡£
´¦Àí±íÖØ¸´¼Ç¼(²éѯºÍɾ³ý)
Â¥ÉϵĺÜÈ«ÁË
http://www.sohu.com
<a href="www.hao123.com">xianlaoy</a>
Ïà¹ØÎÊ´ð£º
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
±àºÅ ¼¶±ð Ãû³Æ Éî¶È
1 0 ÐÂÎÅ 1
2 0 ²Æ¾ 1
3 1 ¾üÊ 2
4 2 ¹ÉƱ 3
5 0 ·¿²ú 1
6 1 Çé¸Ð 2
7 1 ¹úÄÚ 2
8 1 ¹ú¼Ê 2
14 2 ÓÊÕþµçÐÅ 2
15 2 »·±£ 2
16 5 ITÆó ......
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......