SQL ´æ´¢¹ý³Ì

ÏÖÔÚÓÐ2¸öÊý¾Ý¿â,Ò»¸öÔÚ±¾µØ,Ò»¸öÔÚ·þÎñÆ÷ÉÏ.ÏÖÔÚÏëÔÚ±¾»úÀïµÄ´æ´¢¹ý³ÌÖÐʵÏÖ:
²åÈë±¾»úÊý¾Ý¿â(Demo)ÖÐMy(Id,Name)±í,ͬʱ²åÈëÔ¶³Ì·þÎñÆ÷(192.167.1.1)µÄÊý¾Ý¿â(Demo1)ÖÐMy1(Id,Name),Çó½â!

¼òÑÔ¾ÍÊÇ : ´æ´¢¹ý³Ì²åÈëÔ¶³ÌÊý¾Ý¿â!

---

Èç¹û»á,Çë¸ø³öÏêϸ´úÂë!ÔËÐÐͨ¹ý,ÂíÉϽáÌù!!

---

½¨Á¢Á´½Ó·þÎñÆ÷
¿ªÆô·Ö²¼Ê½·þÎñ
½¨Á¢´¥·¢Æ÷
´úÂëµÈÂ¥ÏÂ

---

ÒýÓÃ

½¨Á¢Á´½Ó·þÎñÆ÷
¿ªÆô·Ö²¼Ê½·þÎñ
½¨Á¢´¥·¢Æ÷
´úÂëµÈÂ¥ÏÂ

ÂýÁË

---

--´´½¨Á´½Ó·þÎñÆ÷ 
exec sp_addlinkedserver 'ITSV1', ' ', 'SQLOLEDB ', '192.167.1.1' 
exec sp_addlinkedsrvlogin 'ITSV1', 'false ',null, 'sa ', 'ok ' 

--²éѯʾÀý 
select * from ITSV1.Demo1.dbo.My1

3Â¥±¨Óû§ 'sa ' µÇ¼ʧ°Ü¡£´íÎó!!

---

sa ok ÊÇ·þÎñÆ÷ÃÜÂë.¾ø¶ÔÊǶԵÄ.

---

ÒýÓÃ

--´´½¨Á´½Ó·þÎñÆ÷
exec sp_addlinkedserver 'ITSV1', ' ', 'SQLOLEDB ', '192.167.1.1'
exec sp_addlinkedsrvlogin 'ITSV1', 'false ',null, 'sa ', 'ok '

--²éѯʾÀý
select * from ITSV1.Demo1.dbo.My1

3Â¥±¨Óû§ 's¡­¡­

SQL code:
--ºÃ¶à¿Õ¸ñ
exec sp_addlinkedserver 'ITSV1', ' ', 'SQLOLEDB', '192.167.1.1'
exec sp_addlinkedsrvlogin 'ITSV1', 'false',null, 'sa ', 'ok'

--²éѯʾÀý
select * from ITSV1.Demo1.dbo.My1

---