|
Re: Does anyone use dynamic sql to create temp tables in production environment? [message #40031 is a reply to message #40028] |
Wed, 04 September 2002 10:04 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Not what you want to hear, I know, but I can only argue _against_ dynamically creating/dropping temp tables:
1) Usually there really is no need for a temp table - many people seem to like to break things into superfluous steps.
2) If a temp table is absolutely needed in a rare case, it should be created once, outside of a procedure, as a global temporary table and referenced within code.
|
|
|
|