高考问答深圳山语海在赤湾村 吗:sql 函数解释
来源：百度文库 编辑：高考问答 时间：2024/05/15 07:49:58
set nocount on
select * into #tmp from 作家 where 州<>'ca'
if @@error=0
begin
declare cs1 cursor for
select * from #tmp
open cs1
fetch next from cs1
while @@FETCH_STATUS = 0
begin
fetch next from cs1
end
close cs1
deallocate cs1
end
select * into #tmp from 作家 where 州<>'ca'
if @@error=0
begin
declare cs1 cursor for
select * from #tmp
open cs1
fetch next from cs1
while @@FETCH_STATUS = 0
begin
fetch next from cs1
end
close cs1
deallocate cs1
end