Create/Drop Table Problem

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: