Hi, I have a query that works in SQL Server, but not in H2 1.4.200:
update table set field = sub.rownumber from (select row_number() over (order by (select null)) as rownumber from table) sub The error message claims that there is a syntax error after the first 'from.' Is there a way to do this that works in both SQL Server and H2? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/acab6645-727b-4e5c-9273-0b887848eef4%40googlegroups.com.
