Information générale
Forum:
Microsoft SQL Server
>Fabio,
>
>I'm not sure that you can release declared variables. Their scope is only to the SP, so they're gone when the SP is done anyway. That's not good enough?
>
>~~Bonnie
Absolutely not.
A stored procedures can be much complex and the created temporary tables can be many,
and the duration can be much long (also 1 hour);
if all this comes projected with the access of 1000 or more customers,
the memory allocation becomes much inefficient one.
Too much difficult to make a RELEASE @Table?
Another mystery ?
Fabio
Of course i can use a CREATE TABLE #blabla, but the point is not this.
>
>>I'm not able to found a command for release a Declared Table variable.
>>
>>I cannot think that a way does not exist.
>>If I write a sp very complex one,
>>where i declare 300 table variables !!!
>>
>>Thanks
>>Fabio
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement