sqlserver°²×°²»ÉÏ
ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿
ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿
ÄѵÀ¾µÏñÎļþ¹ýÆÚ±äÖÊÁË?
ÕÒµ½ÀàËÆÏÂÃæµÄĿ¼£¬Ö±½ÓÖ´ÐÐÀïÃæµÄsetup.exe
sql server enterprise 2005\32BIT\Servers
ʲô´íÒ²²»±¨¡£¾µÏñÎļþ¹ýÆÚ±äÖÊÊÇʲô°¡£¿
Èç¹ûÄǸöûʲô¶«Î÷£¡Ö±½Óformat!
ÔÙ×°£¡
ÕÒ°²×°¹ØÅÌÖØÐ°²×°£¬°²×°ÎļþÊÇ·ñÓÐÎÊÌâ
֨װºóÒÔǰ°²×°µÄsqlserver ÎļþûÓÐÈ«²¿É¾³ý£¬½¨Òéµ½×¢²á±íÖÐɾ³ýËùÓÐÓйØsql serverµÄ¼ü£¬Ö®ºó£¬Ò»°ãÇé¿öÏÂÊÇ¿ÉÒÔ°²×°µÄ
²»ÓþµÏñÒ²¿ÉÒÔ×°µÄ£¬»»Ò»¸ö·½Ê½£¬¿ÉÄܾµÏñÎļþÓÐÎÊÌâ¡£
ÓýâѹÎļþµÄÄǸö¹¤¾ß´ò¿ª£¬ÕÒµ½ÀïÃæµÄsetup.exe°²×°ÊÔÊÔ
»»¸ö¾µÏñÊÔһϰÉ,Òª²»ÐÐÖ±½Ó´Ó¹âÇý°²×°ÊÔÊÔ.
Èç¹û²»ÊÇÖØÐ°²×°µÄϵͳ£¬ÇëÔÚ×¢²á±íÖвéÕÒÓйØSQL ServerµÄ×¢²áÄÚÈÝɾ³ý£»
Èç¹ûÊÇÖØÐ°²×°µÄϵͳ£¬¿ÉÄÜÊÇISOÎļþµÄÎÊÌ⣬¿ÉÒÔ½«ËüÈ«²¿¿½±´µ½Ó²ÅÌ£¬¶øºó°²×°——ÔÚ¿½±´µÄ¹ý³Ì¿ÉÒÔÖªµÀÎļþÓÐÎÞÎÊÌâ¡£
SQLÓвÐÁôÎļþ°É¡£¼ÈÈ»ÖØ×°£¬¾Íformatһϡ£°²×°ÎļþûÎÊÌ⣬Ӧ¸Ã²»»á³öʲô´í¡£
Òª°Ñ×¢²á±íµÄËùÓÐSql Server²ÐÁôÈ«²¿É¾µô£¬È»ºóµ½°²È«Ä£Ê½ÏÂÈ¥×°
½¨Òéɾ³ýÒÔǰµÄËùÓÐÎļþ£¬²»È»ºÜ·³µÄ£¡£¡£¡£¡Äã¼ÈÈ»ÒÑ¾ÖØ×°ÁË£¬ÔõôSQL»¹ÔÚ£¿£¿
ÊÇ2005Âð£¿
°¥£¬Êý¾Ý¿âÂù·³µÄ£¬ÎÒͬѧҲÕâÑù£¬ÏÈͬÇéÒ»ÏÂ...
ÏµÍ³ÖØ×°¶¼Ã»Óã¿»»¸öÊý¾Ý¿â³ÌÐò¿Í»§¶Ë°É...
Êǵģ¬ÎÒÊÇÈÏÕæµÄ...
°²×°2000°æ±¾µÄ°É£¬»¹ÊDZȽϺÃÓõģ¡
ÓÐʱºòµÚÒ»´ÎµÄûɾµôËü»áÔÚϵͳÀï±ß²Ð
Ïà¹ØÎÊ´ð£º
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......
ͬÑùµÄÊý¾Ýsqlserver¾¹ýÊÕËõ£¬Çå¿ÕÈÕÖ¾ ×îºó´óСÊÇ196M
ÆäÖÐÖ»ÓÐÒ»¸ö±íµÄÊý¾Ý¶àһЩ ´óÔ¼42ÍòÌõÊý¾Ý£¬µ¼³ö³ÉÎı¾ºóÊÐ62M
µ«ÎÒ°ÑÕû¸öÊý¾Ý¿âµ¼³öµ½ASAÊý¾Ý¿âºóÊý¾ÝÎļþÊÇ48M£¬ÈÕÖ¾ÎļþÊÇ40M£¬
Ϊʲô»á²î±ðÕâô´ó£ ......
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error ......
SELECT *
INTO newtable
from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...±íÃû
Õâ¸ö Êý¾Ýµ¼ÈëµÄ ÆäÖкóÃæµÄ ...±íÃû ......