这是我创建的函数：create function Fun_NewCarOnLineAllAccount
(
   @ServerName  varchar(100),    
   @TerminalSN  varchar(100),   
   @ServerCardNum varchar(20), 
   @endDate datetime,
   @starDate datetime          
)
returns table
as
return(select Brand,Name,ServiceNo,sum(s) as Second,COUNT(*) as Acount,TerminalSN
from
(select ServiceNo,b.TerminalSN,Name,c.Brand,
(case
when states=0 then DATEDIFF(SECOND,LoginIn,LoginOut) end
) as s from TaxiRdDriverLogin b
inner join TR_Car c on b.TerminalSN=c.TerminalSN and c.Isdelete=0
where(@TerminalSN = '' or b.TerminalSN in (@TerminalSN))
and(@ServerName='' or b.ServiceNo in (@ServerName))
and (@ServerCardNum = '' or b.ServiceNo like '%'+ @ServerCardNum +'%')
and ((LoginIn<@endDate and LoginIn>@starDate) or LoginOut is null)
) a group by ServiceNo,TerminalSN,Name,Brand)

我用的时候select * from Fun_NewCarOnLineAllAccount('','086,731','','','')这样查不出数据来。