游标 @@FETCH_STATUS =0 Fetch语句成功 =-1 Fetch语句失败或不在结果集中 =-2 提取的行不存在
通过@@FETCH_STATUS做循环
create table #temp
(
activityid nvarchar(4),
acttype nvarchar(10)
)
declare my_cursor cursor
for select activityid,acttype
from activity
order by activityid desc
open my_cursor
declare
@id nvarchar(4),
@acttype nvarchar(10)
FETCH next from my_cursor
INTO @id,@acttype
while(@@fetch_status=0)
begin
if(Not Exists(select * from #temp Where activityid=@id))
insert into #temp select @id,@acttype
fetch next from my_cursor into @id,@acttype
end
CLOSE my_cursor
DEALLOCATE my_cursor
select * from #temp
drop table #temp
ps：char存取的值会乱码,nvarchar即可解决
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。