alter procedure NList
@User_id int,
@Folder_id int
asselect * from v_AllN
where (User_id =@User_id or @User_id is null)
and (Folder_id=@Folder_id or @Folder_id is null)如果是判断为 '' 的话,把上面的 is null 换成 ='';
不过提醒楼主,上面的语句无法使用索引
@User_id int,
@Folder_id int
asselect * from v_AllN
where (User_id =@User_id or @User_id is null)
and (Folder_id=@Folder_id or @Folder_id is null)如果是判断为 '' 的话,把上面的 is null 换成 ='';
不过提醒楼主,上面的语句无法使用索引
如果参数为空时返回所有记录:select * from v_AllN
where User_id =isnull(@User_id,User_id)
and Folder_id=isnull(@Folder_id,Folder_id)
select * from v_AllN
where User_id like isnull(convert(varchar,@User_id),'%') and Folder_id like isnull(convert(varchar,@Folder_id),'%')