CREATE PROCEDURE [dbo].[IM_huanbao]
@CityId int,
@number int,
@Top int
as
SET ROWCOUNT @Top
select * from 服务商注册信息 where (','+服务商属性+',' Like '%,140003,%' or ','+服务商属性+',' Like '%, 140003,%') and 所在区域=@CityId order by 推荐 Desc,序号 ASC
return
GO
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
对存储过程不熟悉,各位帮帮忙,非常感谢!
我想用number来代替140003,查询语句改怎么改!
@CityId int,
@number int,
@Top int
as
SET ROWCOUNT @Top
select * from 服务商注册信息 where (','+服务商属性+',' Like '%,140003,%' or ','+服务商属性+',' Like '%, 140003,%') and 所在区域=@CityId order by 推荐 Desc,序号 ASC
return
GO
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
对存储过程不熟悉,各位帮帮忙,非常感谢!
我想用number来代替140003,查询语句改怎么改!
@CityId int,
@number int,
@Top int
as
SET ROWCOUNT @Top
select *
from 服务商注册信息
where (','+服务商属性+',' Like '%,' + cast(@number as varchar(100)) + ',%' or ','+服务商属性+',' Like '%, ' + cast(@number as varchar(100)) + ',%')
and 所在区域=@CityId
order by 推荐 Desc,序号 ASC
return
GO