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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
