201508

1 declare @lx varchar(2)
2 set @lx=''
3 select  @lx,* from ZJZHLX where 1=1 and  (zjzhlx_lxbh=@lx or @lx='' or @lx=null) 
原文地址:https://www.cnblogs.com/crsn/p/4718489.html