yep problem is with the compiler.. I had to think of another way to solve

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

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

Answer Posted / lee

yep problem is with the compiler.. I had to think of
another way to solve the problem, eg, I created the #temp
without the IF statement and then used an IF ELSE statement
to modify or update #temp, make sense?

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cdc in sql server?

1004

How to create view in stored procedure sql server?

1021

What are sql azure firewall rules?

106

How to create a stored procedure with a statement block in ms sql server?

1071

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1947

What is SQL Azure Fabric?

110

What is the stuff?

1007

what is normalization? : Sql server database administration

1101

What is primary key and example?

960

Can you please differentiate between a primary key and a unique key?

1010

What is enhanced database mirroring in sql server 2008?

973

What is abstracting periodical?

948

Is INSTEAD OF trigger directly applicable to Table ?

1018

Explain the stored procedure?

1055

Explain the Ways to improve the performance of a sql azure database?