Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔõÑùÔ¶³Ì·ÃÎÊ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Êý¾Ý¿â

ÒýÓÃ
ºÍ·ÃÎʱ¾µØÒ»Ñù¡£·þÎñÆ÷Ãû£¬Êý¾Ý¿âÃû£¬Óû§Ãû£¬ÃÜÂë
·þÎñÆ÷Ãû¿ÉÒÔÊÇÔ¶³Ì·þÎñÆ÷µÄÃû×Ö»òÕßIP¡£
²»¹ýÔ¶³Ì·þÎñÆ÷Òª¿ªÍ¨Ô¶³Ì·ÃÎʵÄȨÏ޲ſÉÒÔ¡£


Õâ¸öÕý½â



Ïà¹ØÎÊ´ð£º

¸ß·ÖÇósqlserverдexcel - MS-SQL Server / ÒÉÄÑÎÊÌâ

1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......

sqlserver saµÇ½ÎÊÌâ¡£ - MS-SQL Server / ÒÉÄÑÎÊÌâ

±¾ÈËÍü¼ÇÁËsaµÄÃÜÂë¡£
ÔÚ¡°°²È«ÐÔ¡±¡ú¡°µÇ¼¡±¡ú¡°saÊôÐÔ¡±¸ü¸ÄÃÜÂëÖ®ºó,ÔÚÖØÐµÇ½¡£
µÇ¼ʧ°Ü¡£
ÓÃwindowsÓû§µÇ½
´úÂë¸ü¸Ä£ºsp_password Null,'123456','sa' »¹ÊÇ
µÇ¼ʧ°Ü¡£
ÔÚ¡°·þÎñ¡±¡ú¡°ÊôÐÔ¡±¡ú¡°µ ......

sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼­ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£

Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£

ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......

¹ØÓÚsqlserverÖеÄÊ¡ÂԺŠ- MS-SQL Server / »ù´¡Àà

SELECT *
INTO newtable
from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 
  'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...±íÃû
Õâ¸ö Êý¾Ýµ¼ÈëµÄ ÆäÖкóÃæµÄ ...±íÃû ......

SqlServer²åÈëÂýµÄÎÊÌâ½â¾ö - .NET¼¼Êõ / ASP.NET

http://blog.csdn.net/realwar/archive/2010/05/29/5632359.aspx
ͦÓд´Ò⣬¾ÓÈ»°Ñ¾Û¼¯Ë÷Òý½¨Á¢ÄÇô¶à×ֶΡ£
Îҵľۼ¯Ë÷Òý¼¸ºõ¶¼ÊÇÀ˷Ѿ͸øidÓá£

¶¥ÏÂÌùÔÙ¿´£¡

see it .

²»´í £¬Õâ¸ö¶«Î÷ÖµµÃÒ»¿´£¡
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ