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