integer 申明有什么作用
declare @max integer;
declare @id integer;
declare cur_rows cursor local for select paydt,count(*) from jngj63.bus63 group by paydt having count(*) > 1;这句有没有语法错误?
open cur_rows;这是什么意思?
fetch cur_rows into @id,@max;
while @@fetch_status=0;
begin
select @max = @max -1;
set rowcount @max;
delete from jngj63.bus63 where paydt = @id;
fetch cur_rows into @id,@max;
end;
close cur_rows;
set rowcount 0;