Using the # prefix for a temporary table creates that table in the tempdb. The ## prefix does the same, but makes it global, so you can access it from other procedures.
Both will persist and need to be dropped to free up memory and disk space.
More here.
No comments:
Post a Comment