Cacher is the code snippet organizer for pro developers

select @@SERVERNAME

--CHECK IF TEMPORARY TABLE EXISTS, AND DROP IT

--SQL SERVER 2014 AND BELOW
IF OBJECT_ID('tempdb..#temporary_table_name') IS NOT NULL  
DROP TABLE #temporary_table_name
 
--SQL SERVER 2016  
DROP TABLE IF EXISTS #temporary_table_name

--I've to do this because when I was starting with sql I used to leave connections opened. **I just use this in my sandbox**, not for production environment.
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'

FROM sys.dm_exec_sessions WHERE database_id  = db_id('Your_DB_Name')

EXEC(@kill)