°ïæ¸ÄÒ»¸öSQLÓï¾ä

SQL code:
select top 6 * into #tmp from
(select top 2 * from [192.168.100.2,1433].wf.dbo.applet a1 order by newid()
union all select top 2 * from [192.168.100.3,1433].wf.dbo.applet a2 order by newid()
union all select top 2 * from [192.168.100.4,1433].wf.dbo.applet a3 order by newid()) A
select *from #tmp


²éÈý¸öÁ´½Ó·þÎñÆ÷µÄ±í£¬ÎÒÈç¹ûÊäÈëµÄÊÇ10µÄ»°£¬ËüÊÇÔõô·ÖÅäÿ̨»úÆ÷Òª²éµÄÊý¾Ý£¿
.ÄѵÀÿ´ÎÊäÈë×ܵÄÈç¡°6¡±È»ºó»¹Òª¼ÆËãÿ¸ö±í·ÖÅä¶àÉÙ£¬ÌîÈë¡°2¡±ÕâôÂ鷳ô...
ÓÐûÓÐÎÒÖ»ÊäÈë6¾Í×Ô¶¯·ÖÅä3¸öÁ´½Ó·þÎñÆ÷ÿÈË2¸öÊý¾Ý...

---

д¶¯Ì¬µÄßÂ

---

.ÄÇ¿ÉÒÔ¼ÓÉϱ¾»úµÄÊý¾Ý¿âÒ»Æð²éÂð

---

ÒýÓÃ

.ÄÇ¿ÉÒÔ¼ÓÉϱ¾»úµÄÊý¾Ý¿âÒ»Æð²éÂð

¿ÉÒÔ£¬ÒòΪÄãÒѽ¨Á¢Á´½Ó·þÎñÆ÷

---

ѧϰÁË

---

ÒýÓÃ

select top 6 * into #tmp from
(select top 2 * from [192.168.100.2,1433].wf.dbo.applet a1 order by newid()
union all select top 2 * from [192.168.100.3,1433].wf.dbo.applet a2 order by newid()
union ¡­¡­

Ç¿ÈË

---

˵·´»°²»ÊǺú¢×Ó!!!