CREATE PROCEDURE XGetCluster
AS
SET NOCOUNT ON
select a.ScopeName, isnull(b.CurrentLoad,'no') As CurrentLoad,isnull(c.ConnectionCount,'no') As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID
AS
SET NOCOUNT ON
select a.ScopeName, isnull(b.CurrentLoad,'no') As CurrentLoad,isnull(c.ConnectionCount,'no') As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID
AS
SET NOCOUNT ON
select a.ScopeName, isnull(b.CurrentLoad,'no') as CurrentLoad,isnull(c.ConnectionCount,'no') As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID
感谢csdn的朋友