Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 18, 1999

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date