Hi,
I would like to use h2 as a testing database, and MS SQL Server 2005
as a production one. The problem I have is with regards to the string
concatenation, where the only supported method in MSSQL is to use a
'+' operator (e.g. select 'he' + 'llo'), whereas h2 supports either a
'he' || 'llo' or concat('he','llo'). As you can see, I have no option
to make this statement work on both dbs without programmatic change. I
understand that the MS SQL Server syntax breaks SQL Standard, but I am
trying to figure out if it is possible to implement this behaviour
together with 'MODE=MSSQLServer' option. Amazingly, hsql supports all
of them, which means '+', '||' and concat().
Anyway many thanks for a great database,
Stepan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
