Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HowTo: Release a Table variable
Message
From
13/01/2005 15:52:07
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00976391
Message ID:
00976933
Views:
15
>>i have no problems to found another way.
>>
>>The point is another:
>>I cannot declare a very long variable like a text, then issue for its release does not exist one.
>>But, why, if i write a sp with a long time processing ( 10 minutes ),
>>and beginning i declare a table variable used just within the first second time,
>>this must remain for 9'59'' to the inside of the virtual memory uselessly ?
>>
>>The MSSQL design is not good here.
>
>I won't argue that it is or is not. It is what it is. You either figure out a way to work around it, or you suffer the performance hit.

Hi Daniel,
This is the just sentence.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform