SqlServer中游标中的例子！
declare @temp_temp intdeclare @Cur_Name varchar(15)Set @Cur_Name='bbb'--------------------------------- 创建游标 --Local(本地游标)DECLARE aa@Cur_Name CURSOR for select House_Id from House_House where Deleted=0 or deleted is null----------------------------------- 打开游标 Open aa@Cur_Name----------------------------------- 遍历和获取游标 fetch next from aa@Cur_Name into @temp_tempwhile @@fetch_status=0begin --做你要做的事 select * from House_monthEnd where House_Id=@temp_temp fetch next from aa@Cur_Name into @temp_temp -- end----------------------------------- 关闭游标 Close aa@Cur_Name------------------------------------- 删除游标 Deallocate aa@Cur_Name--
