declare @ExternalPart varchar(200)
set @ExternalPart='111111,222222'
select Diminutive,UID,Avatar,Sign,ExternalPart,
(SELECT Relation FROM FriendList WHERE FriendList.UID=ua.UID and FriendList.FriendID=10000 and FriendList.Status=2 ) as Flag
from UserAccount ua left join OpenWebLogin owl on ua.UID=owl.AID
where owl.opentype=3 and
charindex(','+ltrim(owl.ExternalPart) +',',','+@ExternalPart+',')>0
and ua.status=1
@ExternalPart 参数这么组织.
set @ExternalPart='111111,222222'
select Diminutive,UID,Avatar,Sign,ExternalPart,
(SELECT Relation FROM FriendList WHERE FriendList.UID=ua.UID and FriendList.FriendID=10000 and FriendList.Status=2 ) as Flag
from UserAccount ua left join OpenWebLogin owl on ua.UID=owl.AID
where owl.opentype=3 and
charindex(','+ltrim(owl.ExternalPart) +',',','+@ExternalPart+',')>0
and ua.status=1
@ExternalPart 参数这么组织.
charindex(','+ltrim(owl.ExternalPart) +',',','+@ExternalPart+',')>0 可不可以解释下这个函数的意思