If Exists for temp tables Auto Replace

Welcome Guest! To enable all features please Login or Register.

#1
Josh Harp
User Profile View All Posts by User View Thanks
Topic Starter
Rank: Member
57.6% (Neutral)

Posts: 12
Joined: 10/2/2017
Monday, October 2, 2017 4:49:43 PM

I have mine set to replace when ife is typed


IF OBJECT_ID(N'tempdb..<tbnm, sysname, table>' 
) IS NOT NULL
BEGIN
    DROP TABLE <tbnm, sysname, table> 
END
#

1 user thanked Josh Harp for this useful post.

SSMSBoost on 10/10/2017

Wanna join the discussion?! Login to your SSMSBoost Add-in discussion board forum account or Register a new forum account

Similar Topics

Auto-replace funniness (Discussions & Announcements) by Andrei 4/1/2014 3:15:01 AM
Auto replace for lastyear (Templates library) by Josh Harp 10/20/2017 8:09:55 PM
Auto Replace for complete update statement (Templates library) by Josh Harp 10/20/2017 8:24:54 PM
Create or Alter Procedure Block Auto Replace (Templates library) by Josh Harp 10/20/2017 8:06:09 PM
Auto replace for creating a merge using 2 table names (Templates library) by Josh Harp 10/20/2017 8:12:12 PM

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Important Information:

The SSMSBoost Add-in discussion board uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close