SP Debug using tempory table created in SQL Editor
Posted: Tue 04 May 2021 19:36
Hi,
I installed the trial version for testing. I opened a new SQL Editor and created a temporary table. Now I need to debug a Stored Procedure that will use this temporary table. The problem is that the SP debugging window cannot see the temporary table created in the other window (SQL Editor). It looks like they are isolated connections. How can I share the temporay table with my SP?
Grateful,
Edward
I installed the trial version for testing. I opened a new SQL Editor and created a temporary table. Now I need to debug a Stored Procedure that will use this temporary table. The problem is that the SP debugging window cannot see the temporary table created in the other window (SQL Editor). It looks like they are isolated connections. How can I share the temporay table with my SP?
Grateful,
Edward