Use of this site constitutes acceptance of our User Agreement (effective 1/2/2014) and Privacy Policy (effective 1/2/2014). Golf Digest may earn a portion of sales from products that are purchased through our site as part of our Affiliate Partnerships with retailers. Your California Privacy Rights The material on this site may not be reproduced, distributed, transmitted, cached or otherwise used, except with the prior written permission of CondÃ© Nast.
Temp table: A Temp table is easy to create and back up data. Table variable: But the table variable involves the effort when we usually create the normal tables. Temp table: Temp table result can be used by multiple users. Table variable: But the table variable can be used by the current user only.
It would be more accurate to say the DELETE is the better option. Nothing to do with table variables you get the same with a #temp table and DELETE. This is quite an edge case in that the 10 rows all fit on one page.TRUNCATE deallocates the last page from the table and DELETE doesn't.t would be more accurate to say the DELETE is the better option. Nothing to do with table variables you get the same with a #temp table and DELETE. This is quite an edge case in that the 10 rows all fit on one page.