How to check whether local temp tables exist or not?

Posted by vishalneeraj-24503 on 11/3/2014 | Category: Sql Server Interview questions | Views: 1842 | Points: 40

Answer:

We have to write tempdb.. followed by Table name in object_id as:-

if(object_id('tempdb..#Employee') is not null)

   Print 'Present';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What's Difference between checking permanent a ...

Next > : Which statement(s) is True about CheckboxList in A ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions