Question

sql bit类型某一个单元格为null,表示为全部；用case when 怎么表示

Answer 1

源码；
create PROCEDURE [dbo].[GetIntentionCust]
@UserID varchar(20),
@Region varchar(400),
@isSA varchar(5)

AS
SET NOCOUNT ON;
declare @Roles varchar(12)
declare @sql varchar(8000)

select @Roles=RoleID from UsersInRoles where UserID=@UserID

set @Region=''''+replace(substring(@region,2,len(@region)-2),',',''',''')+''''
set @sql='select a.UserID as UserID ,
ZMIntentionCust,MIntentionCust,
case
WHEN LMIntentionCust IS NULL THEN 0
ELSE LMIntentionCust
END AS LMIntentionCust,

JLYGIntentionCust,MPIntentionCust,LPIntentionCust from VW_MIntentionCust a
LEFT Join VW_JLYGIntentionCust b ON a.UserID=b.UserID
LEFT Join VW_LMIntentionCust c ON a.UserID=c.UserID
LEFT Join VW_MPIntentionCust d ON a.UserID=d.UserID
LEFT Join VW_LPIntentionCust e ON a.UserID=e.UserID
LEFT Join VW_ZMIntentionCust f ON a.UserID=f.UserID
INNER JOIN V_UserAll g ON a.UserId= g.UserId
'
if @isSA='false'
begin
set @sql=@sql+'and g.DeptCode in ('+@Region+')'
if @Roles='05' or @Roles='08'
begin
set @sql=@sql+' and a.UserID= '''+@UserID+''' '
end
end
print(@sql)
exec(@sql)
select @@rowcount

追问

没看懂你这个长篇大论，不过已解决

Answer 2

case 字段 when 字段 is null then '全部'

Answer 3

isnull(字段,'全部')

Answer 4

这个要配合 程序逻辑的