游标，存储过程，以及临时表

需要在SQL端实现业务逻辑,NND (-_-")

代码一:

ALTER proc [dbo].[tt_select]
@Id bigint
as
select PlanId,FGPartNo,p_FGName from backflush where Id<@Id

 代码二:

Declare @Id bigint
Set @Id=12

Declare @PlanId nvarchar(100),@FGPartNo nvarchar(100),@FGName nvarchar(100)

--确保临时表已经被删除了
IF object_id('tempdb..#t_bf_tmp') IS NOT NULL
  Begin
    Drop Table #t_bf_tmp
  End

--定义临时表
Create Table #t_bf_tmp
(
  PlanId nvarchar(50),
  FGPartNo nvarchar(50) ,
  p_FGName nvarchar(50)
)
--将存储过程的执行结果添加到临时表
Insert Into #t_bf_tmp
Exec tt_select @Id


--使用游标遍历临时表，并做对于处理
Declare MyCursor Cursor
For Select * from #t_bf_tmp
For Read Only

Open MyCursor

Fetch next From MyCursor
   Into @PlanId,@FGPartNo,@FGName

while(@@FETCH_STATUS = 0)
Begin
 print @PlanId  

 Fetch next From MyCursor
   Into @PlanId,@FGPartNo,@FGName
End

Close MyCursor
Deallocate MyCursor

Drop Table #t_bf_tmp