IF OBJECT_ID('tempdb..#Temp') IS NULL
BEGIN
--no existe
END
ELSE
BEGIN
--existe
END