sql中读取垃圾数据

最新推荐文章于 2023-12-18 10:50:50 发布

yelang_110

最新推荐文章于 2023-12-18 10:50:50 发布

阅读量489

点赞数

分类专栏： sqlserver技术交流

本文链接：https://blog.csdn.net/yelang_110/article/details/38120391

版权

sqlserver技术交流专栏收录该内容

4 篇文章 0 订阅

订阅专栏

DECLARE @curGarden CURSOR,@GId INT
Set @curGarden=Cursor For
SELECT distinct(iOrdinal) From dbo.BH_GardenInfo where state=1
OPEN @curGarden
Fetch Next From @curGarden Into @GId
While(@@FETCH_STATUS=0)
begin
select top 1000 u.FUID,u.FileName,u.FilePath,u.GId,u.GCId,r.RValue,g.sName,g.lName from BH_UpFile as u
left join BH_GardenInfo as g on g.iOrdinal = u.GId
left join BH_RecordValue as r
on u.GCId = r.GCID and r.InTime > '2012-09-01'
and r.RValue like 'ftp/'+g.lName+'/___/'+u.FilePath+'/'+u.FUID+'.jpg|(splIter)|'
and
(
r.RValue <> 'ftp/'+g.lName+'/jpg/'+u.FilePath+'/'+u.FUID+'.jpg|(splIter)|'
)
where r.GID = @GId and u.GId = r.GID
Fetch Next From @curGarden Into @GId
end
RETURN