hi Thomas, 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 :) On Friday, November 11, 2011 10:19:51 AM UTC-8, Thomas Mueller wrote: > > Hi, > > The stored procedures and UDFs won't come over, they'd need to be >> redone for H2. >> > > That's true. It doesn't actually matter that much to what database you > migrate to, those most likely need to be re-implemented or at least > changed. There is little standardization in those areas (that I'm aware of). > > Regards, > Thomas > > -- 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/-/pYkzzO3ODxEJ. 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.
