DECLARE BonusBL CURSOR FOR SELECT ID,UserName,CardGames FROM b1219.dbo.Users where ID<>'+cast(@Uid as bigint)+' And ID In ('+Substring(@rePath,2,len(@rePath))+') //不用转换
整形和长整形用不着转换. 可改成: --设@rePath为类似于: ,1,45,68 where ID<>@Uid And charindex(','+convert(varchar,ID)+',',@rePath+',')>0
//不用转换
可改成:
--设@rePath为类似于: ,1,45,68
where ID<>@Uid And charindex(','+convert(varchar,ID)+',',@rePath+',')>0