I have a stored procedure with several steps. Two steps require use DECLARE TABLE, but I do not require these tables at the same time.
There are 2 columns in the tables BIGINTand can contain up to 100 rows.
Is it better to declare two tables or DELETEand reuse one?
EDIT: If you're interested, this is a continuation of the stored procedure developed in this question
source
share