Using Mircosoft SQL Stored Procedures with LANSA
|Date:||3 August 2016|
|Product/Release:||Visual LANSA - All versions|
|Abstract:||Using Mircosoft SQL Stored Procedures with LANSA|
|Submitted By:||LANSA Technical Support|
We are often asked whether, with Visual LANSA you are able to use Microsoft SQL Stored Procedures via the free format SQL command?
The answer is yes, this can be done either using a direct call to the stored procedure or by building the query into a string and passing it into the Select SQL statement.
A section has been added to the LANSA documentation with examples of how you can implement this. Refer to 7.108.2 SELECT_SQL Free Format Examples in the Technical Reference guide.