alter PROCEDURE p_getSmallKindBycid
(
@pagecountint varchar(50)
)
AS
begin
declare @sql varchar(8000)
set @sql=
' select top 21 b.id_fl,b.images_fl,b.youxiaodate_fl,b.sort,b.cname_fl,b.typename,b.isno,b.sort,b.identity_fl,b.price_fl,b.adlink_fl from
(select a.id_fl,a.images_fl,a.youxiaodate_fl,a.isno,b.sort,d.cname_fl,adlink_fl,
c.typename,a.sortid,a.typeid,a.typeid_2 ,a.cid ,a.identity_fl ,e.price_fl
from photo as a,tn8cClass_1 as b,tn8cClass_2 as c,companyinfo as d,price as e
where a.sortid=b.sortid and a.typeid =c.typeid and a.cid=d.id_fl and a.id_fl=e.typeid ) b
where typeid_2=0 and typeid!=0
and id_fl not in (select top '+@pagecountint+' id_fl from photo where
typeid!=0 and typeid_2=0) order by b.youxiaodate_fl 'print (@sql)
exec(@sql)
end
RETURN
(
@pagecountint varchar(50)
)
AS
begin
declare @sql varchar(8000)
set @sql=
' select top 21 b.id_fl,b.images_fl,b.youxiaodate_fl,b.sort,b.cname_fl,b.typename,b.isno,b.sort,b.identity_fl,b.price_fl,b.adlink_fl from
(select a.id_fl,a.images_fl,a.youxiaodate_fl,a.isno,b.sort,d.cname_fl,adlink_fl,
c.typename,a.sortid,a.typeid,a.typeid_2 ,a.cid ,a.identity_fl ,e.price_fl
from photo as a,tn8cClass_1 as b,tn8cClass_2 as c,companyinfo as d,price as e
where a.sortid=b.sortid and a.typeid =c.typeid and a.cid=d.id_fl and a.id_fl=e.typeid ) b
where typeid_2=0 and typeid!=0
and id_fl not in (select top '+@pagecountint+' id_fl from photo where
typeid!=0 and typeid_2=0) order by b.youxiaodate_fl 'print (@sql)
exec(@sql)
end
RETURN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货