【文件属性】:
文件名称:利用游标遍历数据表或者数据集
文件大小:2KB
文件格式:SQL
更新时间:2012-08-12 06:36:56
游标 CUR
declare cur cursor for select AccountID,EmployeeName from #Temp
open cur
fetch next from cur into @tmpID, @tmpName
fetch next from cur into @tmpID, @tmpName
end
close cur
deallocate cur
网友评论
- 很全,什么都有了,感谢.