Set a Variable in Edit Script

Anonymous — Wed, 17 Apr 2013 22:52:18 GMT

How do I set a variable equal to the results of a SQL query?

for example let x = select dbname from table

Re: Set a Variable in Edit Script

Thu, 18 Apr 2013 02:18:27 GMT

You can do it otherway, store the sql query output in table and after that, using peek function you can assign it to any variable.

SQLTableList:

LOAD Name as TableNames;

SELECT Name From AdventureWorksDW2008R2.sys.tables;

let vMyTableName = Peek('TableNames',0,'SQLTableList');

Hope this helps.