SqlServer中流标中的例子

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--