Temp Table in SP

Question

Temp Table in SP

ranuganti

Ten Centuries

Points: 1092
More actions
March 7, 2011 at 11:36 am

#236234

Hi,
Do we need to add the temp table as if exists in the stored procedure before we create it?
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

I think you are asking if you have to wrap the create table with an exists check? You do not have to, but it will throw an exception if the table already exists. Does that answer your question?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ranuganti Ten Centuries Points: 1092 More actions · Answer 2

ranuganti

Ten Centuries

Points: 1092

March 7, 2011 at 12:05 pm

#1295501

Yes,

I got it,

Thank you.

ranuganti Ten Centuries Points: 1092 More actions · Answer 3

Sean Lange,

One more thing, is it necessary to check the temp table if it exists before droping it in the stored procedure?

Thanks a lot.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Same deal. If you try to drop a temp table that doesn't exist it will throw an exception. If you drop an existing temp table it will work fine.