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
SP Debug using tempory table created in SQL Editor
-
- Posts: 1
- Joined: Tue 04 May 2021 19:27
Re: SP Debug using tempory table created in SQL Editor
Unfortunally, it's not possible. In order for the temporary table to participate in debugging, it must be created inside the procedure.