Sqlserver procedure cursor can't parse
csxuyang opened this issue · 0 comments
csxuyang commented
Declare MyCusror Cursor Scroll
For Select * From Master_Goods Order By GoodsID
Open MyCursor
Fetch next From MyCursor
Into @GoodsCode,@GoodsName
While(@@Fetch_Status = 0)
Begin
Begin
insert into B select @GoodsCode,@GoodsName
End
Fetch next From MyCursor
Into @GoodsCode,@GoodsName
End
Close MyCursor
Deallocate MyCursor
cursor can't parse . @goodscode,@GoodsName parser as a constant.