my most used TSQL might be

if object_id('tempdb..#temp',N'U') is not null drop table #temp

go

create table #temp (...)

go

if object_id('some_proc',N'P') is not null drop proc some_proc

go

create proc ...