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
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÔÎĵØÖ·£ºhttp://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm
SQL_TRACEÊÇOracleÌṩµÄÓÃÓÚ½øÐÐSQL¸ú×ÙµÄÊֶΣ¬ÊÇÇ¿ÓÐÁ¦µÄ¸¨ÖúÕï¶Ï¹¤¾ß.ÔÚÈÕ³£µÄÊý¾Ý¿âÎÊÌâÕï¶ÏºÍ½â¾öÖУ¬SQL_TRACEÊǷdz£³£Óõķ½·¨¡£
±¾ÎľÍSQL_TRACEµÄʹÓÃ×÷¼òµ¥Ì½ÌÖ£¬²¢Í¨¹ý¾ßÌå°¸Àý¶Ôsql_traceµÄʹÓýøÐÐ˵Ã÷.
Ò»¡¢ »ù´¡½éÉÜ
(a) ......
Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½Ñ§Linq to sql£¨Áù£©£ºÌ½¾¿ÌØÐÔ
Ò»²½Ò»²½Ñ§Linq to sql£¨Æß£©£º²¢·¢ÓëÊÂÎñ ......
µÚÒ»Ìõ£º
select * from where field in (1,2,3) ÕâÖÖд·¨Ó¦¸ÃÉáÆúÁË£¬¶øÓ¦¸ÃÕâÑùд£º
select * from table where field = 1 or field = 2 or field = 3
ÎªÊ²Ã´ÄØ£¿
·²ÊÂÖ»ÓÐ×ö¹ý²ÅÖªµÀ£¬×Ô¼º½¨¸ö±í£¬²åÈë10WÌõ²âÊÔÊý¾Ý£¬ÓÃsql²âÊÔһϱãÖª£¬ÒòΪ¹¤×÷±ãÀû£¬ÎÒÔÚ²úÆ·»úºÍÍâÍø²âÊÔ»ú¶¼ÒѾ²âÊÔ¹ý£ ......