ALTER proc get_cp @i int,@resid nvarchar(200) as begin declare @nsql varchar(2000) set @nsql='select * from res with(nolock) ' if @i =1 and @resid !='' begin set @nsql=@nsql+' where res_id=''' + @resid +'''' end exec (@nsql) end
ALTER proc get_cp @i int,@resid nvarchar(200) as begin declare @nsql varchar(2000) set @nsql='select * from res with(nolock) ' if @i =1 and @resid !='' begin set @nsql=@nsql+' where res_id=''' + @resid +'''' end exec (@nsql) end