Ejemplo de cursores en SQL Server

declare @tempcursor cursor;
declare @campoUno int, @campoDos int, @campoTres varchar(700);
set @tempcursor=cursor for select campoUno, campoDos, campoTres from ET_EXPEDIENTE_TECNICO;
open @tempcursor
fetch next from @tempcursor into @campoUno, @campoDos, @campoTres;
while @@fetch_status=0
begin
	print @campoTres;
	fetch next from @tempcursor into @campoUno, @campoDos, @campoTres;
end;