写的不够清楚。
存储过程中可以有多个select ,
select top 8 id,biaoti,quyu,data from [ijob_gonggao] where quyu like @quyu order by id desc
select top 8 id_2,biaoti_2,quyu_2,data_2 from [ijob_gonggao] where quyu like @quyu order by id desc
在前台,rs("id"),rs("id_2")这个区别就可以了。
存储过程中可以有多个select ,
select top 8 id,biaoti,quyu,data from [ijob_gonggao] where quyu like @quyu order by id desc
select top 8 id_2,biaoti_2,quyu_2,data_2 from [ijob_gonggao] where quyu like @quyu order by id desc
在前台,rs("id"),rs("id_2")这个区别就可以了。
有时我又需要select top 8 id,biaoti,quyu,data from [ijob_gonggao] where quyu like @quyu order by id desc
如果再写个存储过程如main3,里面select top 8 id,biaoti,quyu,data from [ijob_gonggao] order by id desc这样就可以了。
但是,能不能不再加个存储过程,满足我的要求?
--改一下存储过程就可以了。
Alter PROCEDURE main2
@quyu varchar(20) --@quyu参数控制一下就行了。
as
if isnull(@quyu,'')!=''
select top 8 id,biaoti,quyu,data from [ijob_gonggao] where quyu like @quyu order by id desc
else
select top 8 id,biaoti,quyu,data from [ijob_gonggao] order by id desc
GO