I was trying to find some sample code for Stored Procedures or UDFs in H2. the only information I found was for using Java methods and Aliasing them for use as PROCs.
isn't there a simple way to create a proc in SQL code in H2? for example, let's say that I have the following sample PROC in MSSQL: CREATE PROC spGetItemsForType( @Type int ) as SELECT * FROM ITEMS WHERE TYPE = @Type; is there an equivalent H2 Stored Procedure? can you post the sample code? thanks :) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/I1hIoUPuaZwJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
