34,576
社区成员
发帖
与我相关
我的任务
分享
declare @strSQL1 varchar(1000);
declare @strSQL2 varchar(1000);
declare @strSQL3 varchar(1000);
set @strSQL1='(select top 1000 old.ID,old.title,old.type,old.SmallClassID,old.shi,old.qu from old order by where old.SmallClassID=68 RegDate desc,id desc) as old'
set @strSQL2='SELECT old.ID,old.Title,old.Type,old.SmallClassID,shi.shi,qu.qu FROM ('+@strSQL1+' INNER JOIN shi ON old.shi=shi.id ) INNER JOIN SmallClass1 on old.SmallClassID=SmallClass1.id INNER JOIN qu ON old.qu=qu.id;'
set @strSQL3='SELECT top 1000 old.ID,old.Title,old.Type,old.SmallClassID,shi.shi,qu.qu FROM (((old INNER JOIN shi ON old.shi=shi.ID) INNER JOIN SmallClass1 on old.SmallClassID=SmallClass1.ID) INNER JOIN qu ON old.qu=qu.id) where old.SmallClassID=68 Order by old.RegDate Desc,old.ID Desc;'
execute(@strSQL2)/*方法A*/
execute(@strSQL3)/*方法B*/