一个sql server的存储过程例子

use test
declare persons cursor for select update_time from person;
declare @insertdate datetime;
begin
open persons;
fetch next from persons into @insertdate;
while (@@fetch_status = 0)
begin
print @insertdate
fetch next from persons into @insertdate;
end;
close persons;
end;
deallocate persons