create procedure 名
@XXX varchar(100),
@cookies_member varchar(100),
@cookies_allow varchar(100)
as
begin
declare @sql varchar(1000)
set @sql='select id,style_no,smallimg,isnew,newtime from products where ClassID in '+@xxx+' and (seelevel=''c'''
if @cookies_member='yes'
set @sql=sql+' or seelevel=''b'''
if @cookies_allow=1
set @sql=sql+' or seelevel=''a'''
set @sql=sql+' ) order by isnew desc,seelevel,style_no asc'
end
@XXX varchar(100),
@cookies_member varchar(100),
@cookies_allow varchar(100)
as
begin
declare @sql varchar(1000)
set @sql='select id,style_no,smallimg,isnew,newtime from products where ClassID in '+@xxx+' and (seelevel=''c'''
if @cookies_member='yes'
set @sql=sql+' or seelevel=''b'''
if @cookies_allow=1
set @sql=sql+' or seelevel=''a'''
set @sql=sql+' ) order by isnew desc,seelevel,style_no asc'
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货