Tag Archives: 游标

declare @name varchar(20)
declare @id int
DECLARE author_Cursor CURSOR FOR
SELECT ID, Name
FROM Authors
OPEN author_Cursor
FETCH NEXT FROM author_Cursor into @id,@name
WHILE @@FETCH_STATUS = 0
BEGIN
declare @bid int
declare @title varchar(50)
declare @str varchar(1000)
set @str=”
DECLARE book_Cursor CURSOR FOR
SELECT ID, Title
FROM Books
WHERE Author = @id
OPEN book_Cursor
FETCH NEXT FROM book_Cursor into @bid,@title
WHILE @@FETCH_STATUS = 0
BEGIN
set @str = @str + ‘ 《’ + @title+ ‘》’
FETCH NEXT FROM book_Cursor into @bid,@title
END
CLOSE book_Cursor
DEALLOCATE book_Cursor
insert into newtable values (@id,@name,@str)
FETCH NEXT FROM author_Cursor into @id,@name
END
CLOSE author_Cursor
DEALLOCATE author_Cursor Continue reading →