SQL ServerÈçºÎ¿çʵÀý·ÃÎÊÊý¾Ý¿â
ÔÚÎÒÃÇÈÕ³£Ê¹ÓÃSQL ServerÊý¾Ý¿âʱ£¬¾³£Óöµ½ÐèÒªÔÚʵÀýInstance01ÖпçʵÀý·ÃÎÊInstance02ÖеÄÊý¾Ý¡£ÀýÈçÔÚ×öÊý¾ÝÇ¨ÒÆÊ±£¬ÈçÏÂÓï¾ä:
insert into Instance01.DB01.dbo.Table01
select * from Instance02.DB01.dbo.Table01
ÆÕͨÇé¿öÏ£¬ÕâÑù×öÊDz»ÔÊÐíµÄ£¬ÒòΪSQL ServerĬÈϲ»¿ÉÒÔ¿çʵÀý·ÃÎÊÊý¾Ý¡£½â¾ö·½°¸ÊÇʹÓô洢¹ý³Ìsp_addlinkedserver½øÐÐʵÀý×¢²á¡£
sp_addlinkedserverÔÚMSDNÖе͍ÒåΪ:
sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ]
[ , [ @provider= ] 'provider_name' ]
[ , [ @datasrc= ] 'data_source' ]
[ , [ @location= ] 'location' ]
[ , [ @provstr= ] 'provider_string' ]
[ , [ @catalog= ] 'catalog' ]
ÀýÈ磺ÔÚInstance01ʵÀýÖУ¬Ö´ÐÐÈçÏÂSQLÓï¾ä
EXEC sp_addlinkedserver ‘Instance02’ //ֻдµÚÒ»¸ö²ÎÊý¼´¿É£¬Ä¬ÈÏÇé¿öÏ£¬×¢²áµÄÊÇSQL ServerÊý¾Ý¿â£¬ÆäËû²ÎÊýÓ÷¨Ïê¼ûMSDN¡£
Èç¹ûÄãµÄÁ½¸öʵÀýÔÚͬһ¸öÓòÖУ¬ÇÒInstance01ÓëInstance02Óй²Í¬µÄÓòµÇ½Õʺţ¬ÄÇô¾¹ýÉÏÃæµÄ×¢²áºó£¬Ç°ÃæµÄinsertÓï¾ä¾Í¿ÉÒÔÖ´ÐÐÁË¡£·ñÔò£¬»¹ÐèÒª¶Ô×¢²áµÄÔ¶³ÌʵÀý½øÐеǽÕʺÅ×¢²á£¬ÔÚInstance01ʵÀýÖУ¬Ö´ÐÐÈçÏÂSQLÓï¾ä
EXEC sp_addlinkedsrvlogin 'InstanceName','true' //ʹÓü¯³ÉÈÏÖ¤·ÃÎÊÔ¶³ÌʵÀý
»òÕß EXEC sp_addlinkedsrvlogin 'InstanceName','false','TJVictor,'sa','Password1' //ʹÓÃWindowsÈÏÖ¤·ÃÎÊÔ¶³ÌʵÀý£¬µ±Óû§ÒÔTJVictorÓû§µÇ½Instance01ʵÀý·ÃÎÊInstance02ʱ£¬Ä¬ÈϰÑTJVictorÓ³Éä³Ésa£¬ÇÒÃÜÂëΪPassword1
¾¹ý sp_addlinkedserverʵÀý×¢²áºÍsp_addlinkedsrvloginµÇ½ÕÊ»§×¢²áºó£¬¾Í¿ÉÒÔÔÚInstance01ÖÐÖ±½Ó·ÃÎÊInstance02ÖеÄÊý¾Ý¿âÊý¾ÝÁË¡£
Èç¹û»¹ÎÞ·¨·ÃÎÊ£¬Çë¼ì²é±¾»úDNSÊÇ·ñ¿ÉÒÔ½âÎöÔ¶³ÌÊý¾Ý¿âµÄʵÀýÃû¡£Èç¹ûÎÞ·¨½âÎö£¬¿ÉÒÔÔÚEXEC sp_addlinkedserver ‘Instance02’ÖаÑInstance02»»ÎªIP£¬»òÕßÔÚhostsÎļþÖУ¬×Ô¼º½¨Á¢ÏàÓ¦DNSÓ³Éä¡£
ÏÂÃæÁоټ¸¸ö¿çʵÀýÊý¾Ý¿â·ÃÎʵĴ洢¹ý³ÌºÍÊÓͼ¡£
´æ´¢¹ý³ÌÃû/ÊÓͼÃû
×÷ÓÃ
¾ÙÀý
sp_addlinkedserver
Ïà¹ØÎĵµ£º
/***************************************************
×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
ÈÕÆÚ£º2010.1.5
×¢£º ×ªÔØÇë±£Áô´ËÐÅÏ¢
......
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½Ñ§Linq to sql£¨Áù£©£ºÌ½¾¿ÌØÐÔ
Ò»²½Ò»²½Ñ§Linq to sql£¨Æß£©£º²¢·¢ÓëÊÂÎñ ......
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪ
DDLÓï¾ä£¨Êý¾Ý¶¨ÒåÓïÑÔ£©£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´Ðж¼ÐèÒª½øÐÐÓ²½âÎö¡£»¹ÓÐÒ»Àà¾ÍÊÇDMLÓï¾ä£¨Êý¾Ý²Ù×ÝÓïÑÔ£©£¬ËûÃÇ»á¸ù¾ ......
-- create by zh
-- n ÊÇ×÷ÎïµÄʱ¼ä,x ÊÇÏ£ÍûÔÚ¼¸µã³ÉÊì,·µ»Ø²¥ÖÖµÄʱ¼ä
with t as
(
select 64 n,9 x from dual union all
select 64 n,13 x from dual union all
select 64 n,17 x from dual union all
select 64 n,20 x from dual
)
select '³ÉÊìʱ¼ä:' || lpad(to_char(n),4,' ' ......