游标:
declare @userid varchar(10)
declare Cur cursor for
select userid from [user]open Cur
fetch next from Cur into @userid
while @@fetch_status=0
begin
select * from [Detail] where userid=@userid
fetch next from Cur into @userid
endclose Cur
deallocate Cur
declare @userid varchar(10)
declare Cur cursor for
select userid from [user]open Cur
fetch next from Cur into @userid
while @@fetch_status=0
begin
select * from [Detail] where userid=@userid
fetch next from Cur into @userid
endclose Cur
deallocate Cur
create proc p_test
as
declare @i int,@count int
select id=identity(int,1,1),UserName,UserID into #t from [Users]
select @count=@@rowcount,@i=1
while @i<=@count
begin
select * from [Detail] where userid=(select userid from #t where id=@i)
set @i=@i+1
end
go