34,838
社区成员




CREATE procedure ProList
@myname varchar(100),
@orderby int
as
begin
if @orderby=1
select id,myname,price from [pro]
where online=1
and myname like '%'+@myname+'%'
order by price1 desc
else if @orderby=2
select id,myname,price from [pro]
where online=1
and myname like '%'+@myname+'%'
order by price1
else
select id,myname,price from [pro]
where online=1
and myname like '%'+@myname+'%'
order by id desc
end
go
CREATE procedure ProList
@myname varchar(100),
@orderby int
as
declare @s varchar(5000)
set @s='select id,myname,price from [pro] where online=1 and myname like '''+ '%'+@myname+'%'''
if @orderby=1
exec(@s+' order by price1 desc')
else if @orderby=2
exec(@s+ ' order by price1 asc')
else
exec (@s+'order by id desc')
CREATE procedure ProList
@orderby int
as
begin
select top 10 id,type,subject from [table1] order by case @orderby when 1 then id when 2 then type end desc
end
CREATE procedure ProList
@orderby int
as
begin
select top 10 id,type,subject from [table1] order by case @orderby when 1 then id when 2 then type end desc
end