Question

各位大侠帮帮忙，怎样把这段存储过程转换为SQL语句，在线等，先谢谢了！

create proc SelectProduct
@ProdID varchar(10),
@ProdName nvarchar(30),
@CategoryID varchar(5),
@MinPrice decimal(10,2),
@MaxPrice decimal(10,2)
as
declare @sql varchar(2000)
set @sql='select * from Product where 1=1'
if @ProdID<>''
set @sql=@sql+' and ProdID like ''%'+@ProdID+'%'''
if @ProdName<>''
set @sql=@sql+' and ProdName like ''%'+@ProdName+'%'''
if @CategoryID<>'ALL'
set @sql=@sql+' and CategoryID='''+@CategoryID+''''
if @MinPrice<>-1
set @sql=@sql+' and Price>='+cast(@MinPrice as varchar)
if @MaxPrice<>-1
set @sql=@sql+' and Price<='+cast(@MaxPrice as varchar)
set @sql=@sql+' order by AddTime desc'
--print @sql
exec(@sql)

Answer 1

整个过程相当于执行如下语句：
select * from Product

如果过程没写错，应是如下意思吧：
select * from Product
where (@ProdID = '' or ProdID like '%'+@ProdID+'%')
and (@ProdName = '' or ProdName like '%'+@ProdName+'%')
and (@CategoryID = 'ALL' or CategoryID = @CategoryID)
and (@MinPrice = -1 or Price >= @MinPrice)
and (@MaxPrice = -1 or Price <= @MaxPrice)
order by AddTime desc

Answer 2

转化要点功力！

Answer 3

就是if再判断 执行语句而已
你要转换sql语句的话 用其他网页编程 查询相关字段 再If 再执行不就OK了么