>

>IF OBJECT_ID('TempDB..#Temp', N'U') IS NOT NULL DROP TABLE #Temp;
>
>select numero into #Temp from dbo.Country where Country.Numero < 10;

>
>The first check with object_id will verify if the table already exists or not and will drop it if it exists.

Thanks, as I understand this is window query session related. Is that correct?

When doing this, is there some kind of changes that is applied to the database itself or this is memory only?