请用这样的语句试试：
select top {$Param(0)} ID,Tid,Title,Adddate from KS_Article where Tid in(select ID from KS_Class where TS like '%{$Param(1)}%') order by Adddate desc