lovasoa opened a new issue, #1489:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1489

   Initially reported in SQLPage as 
https://github.com/sqlpage/SQLPage/discussions/655
   
   Currently, sqlparser supports stored procedure calls with
   
   ```sql
   EXECUTE MyProcedure;
   ```
   
   However, the Microsoft SQL Server syntax does support passing parameters to 
stored procedures with a simple whitespace between the procedure name and 
arguments:
   
   ```sql
   EXECUTE MyProcedure 'argument 1', 'argument 2';
   ```
   
   It also supports named arguments
   
   ```sql
   EXECUTE MyProcedure @my_first_arg = 'argument 1', @my_second_arg = 'argument 
2';
   ```
   
   
   reference: 
https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/execute-a-stored-procedure?view=sql-server-ver16
   
   Related, but different issues:
    - https://github.com/apache/datafusion-sqlparser-rs/issues/1275
    - https://github.com/apache/datafusion-sqlparser-rs/issues/1276


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to