sqlparser / gsp_demo_java

Java demos for the General SQL Parser library
127 stars 68 forks source link

Sqlserver procedure cursor can't parse #13

Closed csxuyang closed 3 years ago

csxuyang commented 3 years ago
        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.