# re: 雑記
2005/06/19 2:58 by
--select id, parentid, title from blog_content where Title like '%nohhtatu%'
DECLARE @id varchar(20), @parentid varchar(20), @count int, @sum int, @feedback int
set @count=1
DECLARE mycursor CURSOR
FOR
SELECT id,parentid
FROM blog_content
where posttype =1
OPEN mycursor
FETCH NEXT FROM mycursor INTO @id, @parentid
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
SELECT @sum = count(*) from blog_content where parentid=@id
SELECT @feedback = FeedBackCount FROM blog_content where id=@id
--SELECT @count, @id, @sum, @feedback
Update blog_Content Set FeedBackCount = @sum where [ID] = @ID
--SELECT @sum = count(*)-1 from blog_content where parentid=@parentid
--SELECT @feedback = FeedBackCount FROM blog_content where id=@parentid
--SELECT @count as '#', @id as id, @parentid as parentid, @sum, @feedback
--DELETE blog_content where id=@id
--Update blog_Content Set FeedBackCount = @sum where [ID] = @ParentID
set @count = @count + 1
END
FETCH NEXT FROM mycursor INTO @id, @parentid
END
CLOSE mycursor
DEALLOCATE mycursor
# re: 雑記
2005/06/22 4:22 by
DECLARE @id varchar(20), @parentid varchar(20)
DECLARE mycursor CURSOR
FOR
SELECT id,parentid
FROM blog_content
where posttype =3 and Title like '%hcdgbkmqy%'
OPEN mycursor
FETCH NEXT FROM mycursor INTO @id, @parentid
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
DELETE blog_content where id=@id
Update blog_Content Set FeedBackCount = FeedBackCount-1 where id=@parentid
END
FETCH NEXT FROM mycursor INTO @id, @parentid
END
CLOSE mycursor
DEALLOCATE mycursor
# re: 雑記
2005/07/10 18:01 by