it indicates that some one had already executed the stored proc but forgo

create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end

while executeing the above code it shows error
like '#temp already exist' .why it shows an error?

Question Posted / david

8 Answers
10610 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / david

it indicates that some one had already executed the stored
proc but forgotten to delete the temp table they have
created.

normally before closing that particular transaction within
the SP we need to use drop table statement.

Is This Answer Correct ?

1 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens when unicode strings concatenate with non-unicode strings?

1023

Difference between 2NF &3NF ?

1041

What is default constraint in ms sql server?

978

if no size is defined while creating the database, what size will the database have? : Sql server administration

954

How to disable stored procedure sql server?

1546

What is the difference between mysql and sql server?

959

What are the different authentication modes in sql server?

1064

What are the disadvantages of indexes?

1019

What are sub reports?

192

How to connect a database with sql express.?

1024

Explain why variables called the most powerful component of ssis?

1017

What are the different types of cursor?

1051

How do you drop an index?

875

Is natural join and equi join same?

922

Does partitioning ssd reduce performance?

865