create procedure searchproducts @key varchar(50), @cookies_member varchar(3), @cookies_allow varchar(1) as begin declare @sql varchar(200) set @sql='select id,style_no,smallimg,ClassID,isnew,newtime,Img_Name from products where (Style_No like ''%'+@key+'%'' or Content like ''%'+@key+'%'') 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'select @sql ------execute(@sql)--先注释掉end---***在查询分析器里**--先按Ctrl+Tuse 你的数据库 searchproducts '参数1','参数2','参数3'
@key varchar(50),
@cookies_member varchar(3),
@cookies_allow varchar(1)
as
begin
declare @sql varchar(200)
set @sql='select id,style_no,smallimg,ClassID,isnew,newtime,Img_Name from products where (Style_No like ''%'+@key+'%'' or Content like ''%'+@key+'%'') 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'select @sql
------execute(@sql)--先注释掉end---***在查询分析器里**--先按Ctrl+Tuse 你的数据库
searchproducts '参数1','参数2','参数3'
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
CoolAbu 的形象大使,禁止盗版!