Because temp is being used by database internally so that it is same as a

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 / gaurav

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

Answer Posted / gaurav

Because temp is being used by database internally so that it
is same as a system table so this table can't create by user...

Is This Answer Correct ?

1 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why are sql functions used?

1107

Explain about nested stored procedure?

1018

Do you know what is rank function?

1069

How to insert data into an existing table?

964

What is BCNF? How is it better than 2NF & 3NF?

1006

When I delete any data from a table, does the sql server reduce the size of that table?

1002

Explain how to integrate the ssrs reports in application?

1004

How to call stored procedure using http soap?

1064

What are policy management terms?

974

What is the main purpose of having conversation group?

894

How to download and install sql server 2005 books online?

1166

Explain the steps to use transact-sql cursor?

1039

What is key set driven?

941

What are the properties of the relational tables?

871

What are subqueries in sql server? Explain its properties.

1005