34,593
社区成员
发帖
与我相关
我的任务
分享
declare @ID int,
@UID int
set @ID=1
set @UID=1
select * from FileManager
where FolderID =(select ID from FolderManager where ID=@ID)
and ID in(select FileID from FileRight
where InfoUserIDs like '%'+CAST(@UID as varchar(20))+'%')
declare @ID int,
@UID int
set @ID=1
set @UID=1
select * from FileManager
where FolderID =(select ID from FolderManager where ID=@ID)
and ID in(select FileID from FileRight
where charindex(CAST(@UID as varchar(20))+',',InfoUserIDs)>0)
where ','+InfoUserIDs+',' like '%,'+CAST(@UID as varchar(20))+',%')