Hi, I am evaluating some in-memory databases. *I need to know wether H2Database supports SQL variables? *
Statements like: "DECLARE @clientAppInstId VARCHAR(50)" *My Query works in the SQL database and I need a InMemory database for test cases purpose which can run this query given below:* DECLARE @clientAppInstId VARCHAR(50) SET @clientAppInstId = (SELECT ClientAppInstanceId FROM core_securityToken WHERE TokenId = '1234') IF(@clientAppInstId is null) SELECT cst.UserId FROM dbo.core_SecurityToken cst (NOLOCK) ELSE SELECT cst.Uri FROM dbo.core_SecurityToken cst (NOLOCK) *This query will require the support of SQL Variables and IF/ELSE keywords.* *Need to know is this supported in **H2Database** on an urgent basis? I am in the middle of a sprint. Quick answer will be highly appreciated.* *Best,* *Shivam* -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
