sqlparser/gsp_demo_java

Sqlserver procedure cursor can't parse

csxuyang opened this issue · 0 comments

        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.