create procedure test
as
declare @bookid as varchar(30)
declare lei_cursor CURSOR FOR
create table #tmp(
id smallint identity(1,1),
bookname varchar(50)
)
declear lei_cursor cursor for
select bookid from code_book
open lei_cursor
FETCH NEXT FROM lei_cursor INTO @bookid
--------------------------开始循环查找-----------------------------
WHILE @@FETCH_STATUS = 0
begin
insert #tmp (bookname)
select @bookname from code_book where bookid=@bookid
FETCH NEXT FROM lei_cursor INTO @bookid
end
close lei_cursor
DEALLOCATE lei_cursor
select * from #tmp
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货