Citação:
CREATE function [dbo].[fn_info]
(
)
RETURNS @tabela TABLE
(
-- Columns returned by the function
valor1 int,
valor2 int,
valor3 int,
valor4 int,
valor5 int,
valor6 int,
valor7 int,
valor8 int
)
AS
begin
declare @valor1 int
declare @valor2 int
declare @valor3 int
declare @valor4 int
declare @valor5 int
declare @valor6 int
declare @valor7 int
declare @valor8 int
select @valor1 = COUNT(*) from MEMB_STAT where ConnectStat=1
select @valor2 = COUNT(*) from MEMB_INFO
select @valor3 = COUNT(*) from Character
select @valor4 = COUNT(*) from Character where CtlCode=1
select @valor5 = COUNT(*) FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id join AccountCharacter on Character.Name = AccountCharacter.GameIDC WHERE CtlCode > 7 and Memb_Stat.ConnectStat = 1
select @valor6 = COUNT(*) FROM Character WHERE CtlCode > 7
select @valor7 = COUNT(*) from muonline2.dbo.MEMB_INFO
select @valor8 = COUNT(*) from muonline2.dbo.Character
INSERT @tabela
SELECT @valor1, @valor2, @valor3, @valor4, @valor5, @valor6, @valor7, @valor8;
return;
end
GO