相当于下面实现的功能:
select top 0 * into #test from employee
declare @s_empid varchar(20)
declare c_getempid cursor for
select distinct emp_id
(
select top 50 * from employee order by emp_id
) as info
open c_getempid
fetch next from c_getempid into @s_empid
while @@fetch_status = 0
begin
insert #test
select top 50 * from employee where emp_id = @s_empid order by emp_id
fetch next from c_getempid into @s_empid
end
close c_getempid