Unfortunately, this is not that simple.

I tried

IF object_id('tempdb..#temp_Registration') is not null
insert into Registration select * from #Temp_Registration

But I'm getting an error Msg 213, Level 16, State 1, Line 10
Insert Error: Column name or number of supplied values does not match table definition.

I guess I need to research this problem in more details ...

>>Hi everybody,
>>
>>I want to have a create table script which I can execute multiple times (so I would need to have drop statements first).
>>
>>I also would like to be able to preserve existing data.
>>
>>Is there a way to write such a script?
>>
>>Thanks a lot in advance.
>
>Isn't there something like a temp table in sqlserver ?