SqlServer中流标中的例子

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