ÔõÑùÔ¶³Ì·ÃÎÊsqlserver 2005
ÎÒÏëÔÚÁíһ̨»úÆ÷ÉÏ·ÃÎʱ¾»úµÄsqlserver 2005 ¸ÃÔõôÅäÖá£Òª·ÃÎʵĻúÆ÷°²×°ÁËsqlserver 2005ÓõIJÙ×÷ϵͳÊÇwindows 2003 £¬Òª½øÐÐÔ¶³Ì·ÃÎʵĻúÆ÷Ò²°²×°ÁËsqlserver 2005 ÓõIJÙ×÷ϵͳÊÇwindows £Ø£Ð¡£¸ÃÔõôÅäÖòÅÄÜÈÃÁ½Ì¨»úÆ÷µÄÊý¾Ý¿â»¥Ïà·ÃÎÊ¡£ÏëÇë¸ßÊÖÖ¸µãһϡ£
ͨ¹ýipµØÖ·¾Í¿ÉÒÔ·ÃÎÊ¡£
ÊäÈëIP£¬Userid£¬password¾Í¿ÉÒÔÁË£¡~
Á½Ì¨µçÄÔÒªÁ¬Í¨£¬¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£
¡°¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷¡±
ÔÚ¡°SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¡±Ò³, µ¥»÷¡°·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷¡±
È»ºóµ¥»÷Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°Ô¶³ÌÁ¬½Ó¡±£¬ÔÚÓÒ±ßÑ¡ÖС°±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡±£¬
ÔÙÑ¡ÔñҪʹÓõÄÐÒ飬( Õâ¸öµØ·½Ó¦µ±ÆôÓÃTCP/IP ºÍÃüÃû¹ÜµÀ·þÎñ£¡)µ¥»÷¡°Ó¦Óá±£¬
Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°·þÎñ¡±£¬ÔÚÓұߵ¥»÷¡°Í£Ö¹¡±£¬µÈµ½ MSSQLSERVER ·þÎñÍ£Ö¹£¬
È»ºóµ¥»÷¡°Æô¶¯¡±£¬ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ¡£
http://topic.csdn.net/u/20090110/08/028e238a-e190-409e-b7d5-0d0c08b23df4.html
¿ªÆôSqlClient·þÎñ
ÉèÖ÷À»ðǽ
3¥˵µÄ¹»ÏêϸÁË¡£¡£
ͬÒâÉÏ
up
ºÍ·ÃÎʱ¾µØÒ»Ñù¡£·þÎñÆ÷Ãû£¬Êý¾Ý¿âÃû£¬Óû§Ãû£¬ÃÜÂë
·þÎñÆ÷Ãû¿ÉÒÔÊÇÔ¶³Ì·þÎñÆ÷µÄÃû×Ö»òÕßIP¡£
²»¹ýÔ¶³Ì·þÎñÆ÷Òª¿ªÍ¨Ô¶³Ì·ÃÎʵÄȨÏ޲ſÉÒÔ¡£
ÔÚA»úÌí¼ÓB»úµÄsqlÊý¾Ý¿â
Õâ¸öÕý½â
Ïà¹ØÎÊ´ð£º
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......
±¾ÈËÍü¼ÇÁËsaµÄÃÜÂë¡£
ÔÚ¡°°²È«ÐÔ¡±¡ú¡°µÇ¼¡±¡ú¡°saÊôÐÔ¡±¸ü¸ÄÃÜÂëÖ®ºó,ÔÚÖØÐµÇ½¡£
µÇ¼ʧ°Ü¡£
ÓÃwindowsÓû§µÇ½
´úÂë¸ü¸Ä£ºsp_password Null,'123456','sa' »¹ÊÇ
µÇ¼ʧ°Ü¡£
ÔÚ¡°·þÎñ¡±¡ú¡°ÊôÐÔ¡±¡ú¡°µ ......
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£
Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£
ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......
SELECT *
INTO newtable
from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...±íÃû
Õâ¸ö Êý¾Ýµ¼ÈëµÄ ÆäÖкóÃæµÄ ...±íÃû ......
http://blog.csdn.net/realwar/archive/2010/05/29/5632359.aspx
ͦÓд´Ò⣬¾ÓÈ»°Ñ¾Û¼¯Ë÷Òý½¨Á¢ÄÇô¶à×ֶΡ£
Îҵľۼ¯Ë÷Òý¼¸ºõ¶¼ÊÇÀ˷Ѿ͸øidÓá£
¶¥ÏÂÌùÔÙ¿´£¡
see it .
²»´í £¬Õâ¸ö¶«Î÷ÖµµÃÒ»¿´£¡
......