SQL Kernel: A T-SQL variable is not visible / accessible outside of cell context

[PiJoCoder]

Issue Type: Bug

Step 1. Create a new cell using Add Code and paste this:
declare @a int = 100 select @a
Step 2. Create yet another cell using Add Code and paste this:

select @

Step 3. Run Cells

You will get this error which indicates that variables in the SQL kernel are only cell-scope. In the Python kernel they are available in the entire Notebook

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@A".

Azure Data Studio version: azuredatastudio-insiders 1.13.0-insider (34fe2b4, 2019-10-24T07:49:24.669Z)
OS version: Windows_NT x64 10.0.18362

[chlafreniere]

Hi @PiJoCoder. For now, this is known behavior.

[PeterH-OSAS]

Hello. I know this isn't the most exciting feature to implement. It is quite serviceable and I'm wondering how we might gain some traction for its implementation. I can see this being valuable in preparing some training material for debugging and troubleshooting stored procedures by breaking down the individual statements.

This behavior does deviate from a Python notebook and is an item I've been eagerly anticipating being resolved. If there could be given consideration to its placement in the backlog and advancing it forward, it would be appreciated. Thank you in advance for reviewing my comments.

Respectfully,
Peter

[himadrinath]

@kburtram @chlafreniere eagerly waiting.......🙄

[phierru]

It is acrucial funtion, should be a priority. That's how notebooks work in other languages. For instance you want to execute 5 queries with the same date range, that changes between workbook executions. Otherwise you are better off with search and replace in notepad.

Workaround: You can use the session context to store and retrieve the variables. See this approach: https://www.ericgharrison.com/?p=418