这样就OK了。
create proc pro_DeplayGI
(
@Deplay int
)
as
begin
if(@Deplay=1)
begin
select top 4 * from tb_BookInfo
where isrefinement=1
end
else if(@Deplay=2)
begin
select top 4 * from tb_BookInfo
where IsDiscount=1
end
else if(@Deplay=3)
begin
select top 4*from tb_BookInfo
where IsHot=1
end
end
go
create proc pro_DeplayGI
(
@Deplay int
)
as
begin
if(@Deplay=1)
begin
select top 4 * from tb_BookInfo
where isrefinement=1
end
else if(@Deplay=2)
begin
select top 4 * from tb_BookInfo
where IsDiscount=1
end
else if(@Deplay=3)
begin
select top 4*from tb_BookInfo
where IsHot=1
end
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货