declare somevariable int;

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

Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: sqlsvr
To: firebird-support@yahoogroups.com
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]