Sql 存储过程动态添加where条件 

declare @bussHallId nvarchar(255)= '2,3'
declare @strWhere nvarchar(255)= ''
declare @strMain nvarchar(500)
if(@bussHallId is not  null)
    set @strWhere = @strWhere + ' and bh.ID in ('+@bussHallId+')'
    
set @strMain = ' select * from T_BussHall bh
where 1 =1 ' +@strWhere

exec(@strMain)
posted @ 2016-03-18 11:07  Kimisme  阅读(1843)  评论(0)  编辑  收藏  举报