Call function with wrong order parameters

Today, i made a mistake, when i  call a function, pass the wrong order of the parameters,
such as
ShowReport(GroupID, ClassID,ProcessID);
but when i use, just call as
ShowReport(GroupID, ProcessID,ClassID);
so i use the parameters can get right result in ssms(sql server manage studio), but wrong in program.
sould take care  detail info

select pc.GroupCount, pp.ProcessID,pi.ProcessName,Hits, CostTime
from [PerLogDB].[dbo].T_PerformanceInfo as pp, [PerLogDB].[dbo].T_CaseInfo as pc, [PerLogDB].[dbo].T_ProcessInfo as pi
where
pc.GroupID = 100 and pp.ClassID=2000
and  pp.CaseID=pc.CaseID and pp.ProcessID=pi.ProcessID and pp.ProcessID=310000
and pp.TimeStamp ='3/4/2012';

posted on 2012-03-06 14:45  子虚乌有  阅读(174)  评论(0)    收藏  举报