HomeActive Query BuilderSQL Declare statements

SQL Declare statements

Is there a method to allow for declaring variables as part of the SQL? I use this ALOT everyday especially when testing SQL from procedures, etc.

I would like to be able to process
Declare @myvar varchar(20)
set @myvar = 'WILL_IT_WORK'
select * from table1 join table2 on table1.key = table2.key
where table1.key = @myvar

This is a wish list item.
AJ | email
May 25 2009, 01:45 PM
Dear Alvin,

Thank you for your suggestion.

The current version can not parse Declare and Set statements, but we have this item in our to-do list.
Sergey Smagin | email
15 hours, 51 mins since original post
This topic is closed