1.
select * from a where creatorid='1' or ','+[group]+',' like '%,1,%'2.
select id,creatorid,case creatorid when '12' then [group] else 'yes' end [group]
from a
select * from a where creatorid='1' or ','+[group]+',' like '%,1,%'2.
select id,creatorid,case creatorid when '12' then [group] else 'yes' end [group]
from a
第一条好像不行,比如 userid=11,group=1,creatorid!=11时,它还会显示这条记录,原则上是不要显示的。 这个问题还好办,用charindex就可以解决。主要是合并两条规则具体改如何写 多谢!
显然不成立
select * from where ',1,' like ','+str(creatorid)+','+group+','
you are right。thank
where ',12,' like ','+str(creatorid)+','+group+','
select id,creatorid,
case creatorid when @userid then [group] else 'yes' end [group]
from a
where creatorid=@userid or ','+[group]+',' like '%,'+@userid+',%'
from a
where ',12,' like ','+str(creatorid)+','+[group]+','谢谢pbsql(风云)的提醒,[group]!
from a
where ',12,' like ','+str(creatorid)+','+[group]+','