excelÊý¾Ýµ¼ÈëSQLSERVERÎÊÌâ
ÎÒÓÃ insert into table select * from '+
'OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source="'+opendialog1.FileName+'";User ID=;Password=;Extended Properties=Excel 8.0;Persist Security Info=False'')...sheet1$' ;
ʵÏÖexcelµÄÊý¾Ýµ¼Èëµ½SQL SERVERÀÓÐÒ»µã¸ã²»Ã÷°×£¬¾ÍÊÇ˵EXCELÀïÃæµÄ±íµÄ×ֶκÍSQL SERVERÀïÃæ±ítableµÄ×ֶαØÐëÒ»Ñù²ÅÄܵ¼ÈëÂð£¿Äܲ»ÄÜÔÚSQL SERVERÀïн¨Ò»¸ö±íµ¼È룬¾ßÌåµÄÓï¾äÔõÑùʵÏÖµÄÄØ£¬¸ÕѧdelphiºÜ¶àÎÊÌⶼ²»¶®¡£Ð»Ð»¸÷λ´óϺÁË
ÏòÄãÕâÖÖд·¨£¬×ֶξͱØÐëµÃÒ»Ò»¶ÔÓ¦£¬Èç¹ûÓÖ²»Ò»ÑùµÄ×ֶΣ¬Äã¾ÍÒªÖ¸Ã÷×Ö¶ÎÃû£¬±ÈÈç
insert into A(a,b,c) select d,e,f from B
LZµÄÎÊÌâ²»ÊÇDelphiÎÊÌ⣬ÊÇSQL²»ÊìÁ·
ÊÇ
Ïà¹ØÎÊ´ð£º
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæʱ²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
ÈçÌâ:
sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ..
×îºÃÓÅ»¯ ²»Ëãʲô
ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊǺܺõÄ
sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý
Ö ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË
²»Ã÷°×£¬ÄÜ×Ðϸ ......