On Tuesday, February 19, 2013 10:48:28 AM UTC+1, Lukas Eder wrote: > And here is a new corner-case: > > - "SELECT 1 FROM ..." Some databases cannot handle unnamed columns in > subqueries. E.g. SQL Server can't run SELECT count(*) FROM (SELECT 1). > It would have to be changed to SELECT count(*) FROM (SELECT 1 [dummy]) >
I've never worked with SQLServer and have none at hand to test this, but would COUNT(1) make it work in this case? -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
