Subject Re: [firebird-support] SQL Server Migration to Firebird
Author Ismael L. Donis GarcĂ­a
declare somevariable int;

somevariable = 1;
SELECT :somevariable as column1 FROM RDB$Database;

|| ISMAEL ||
----- Original Message -----
From: sqlsvr
Sent: Thursday, July 01, 2010 5:22 PM
Subject: [firebird-support] SQL Server Migration to Firebird

In SQL Server, you can do this in the Query Analazyer (which executes a query and displays the results):

SELECT 'a' AS column1;

You can also do this:
DECLARE @somevariable INT;
SET @somevariable = 1;
SELECT @somevariable;

Can someone translate this to Firebird SQL?

I tried running the queries in the "query analyzer" in Flamerobin but it would not run explaining of an "unexpected end of command"

[Non-text portions of this message have been removed]