When I debug a sql script, and I am going step by step thru script, I can't see varibales even if they are correctly set. For example:
SELECT 'asdsdasd' INTO @myvariable; SELECT id INTO @myid FROM mytable WHERE some_column = @myvariable;
Both @myvariable and @myid when I add them to the watch list I see <Unknown identifier @myvariable> and <Unknown identifier @myid> as their values. Also when I hover with mouse over them I see the same value - <Unknown identifier ...>
Is there a way to debug a script step by step and see the values of variables while debugging?