34,838
社区成员




select top 10 *
from
(
Select Title AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other
Where [Other_Title] Like '%河北%'
UNION
Select s_name AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi
Where [s_name] Like '%河北%'
Order By [Title] DESC
) T Order By [Title] DESC
select top 10 * from (
Select Title AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other
Where [Other_Title] Like '%河北%'
UNION
Select s_name AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi
Where [s_name] Like '%河北%'
Order By [Title] DESC
) t
select top 10 from (
Select Title AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other
Where [Other_Title] Like '%河北%'
UNION
Select s_name AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi
Where [s_name] Like '%河北%'
Order By [Title] DESC
) t