Question:
When I execute this query:
create table #T1 ( pk numeric( 9 ) ) drop table #T1 create table #T1 ( pk numeric( 9 ) ) drop table #T1
The second create
can’t execute because there’s already an object #T1. So the first Drop hasn’t done its job when the second create
starts.
Why and how can I solve this problem?
Answer:
I think your problem will go away when you insert a GO
between each line.