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
10571 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

What is updatable resultset?

946

How do we know if any query is retrieving a large amount of data or very little data?

926

How to set database to be read_only in ms sql server?

962

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1107

Explain ms sql server reporting services vs crystal reports?

861

what are acid properties? : Sql server database administration

932

Explain the steps to use transact-sql cursor?

973

Which is faster statement or preparedstatement?

898

Explain time data type in sal server 2008?

878

What are scalar functions in sql?

1086

Can we use having clause without group by?

933

what data regions are and what are the different data regions?

132

Explain activity monitors

1014

What are the common performance issues in sql server?

874

When to use null data driven subscription?

200