Hiiii in Stored Procedures we cannot create same temp table twice if

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 / madhu sudhan g

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

Answer Posted / madhu sudhan g

Hiiii

in Stored Procedures we cannot create same temp table twice if it is in IF else conditions also

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we call stored procedure in trigger?

911

Explain iaas, paas and saas?

How to call stored procedure using http soap?

1007

What are the new security features added in sql server 2012? : sql server security

961

What are the steps you should follow to start sql server in single-user mode?

854

Where is trigger in sql server?

997

Define normalisation?

1068

What is the contrast between sql and pl/sql?

1083

What is dimension table? : sql server analysis services, ssas

979

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2167

What is sub-query in sql server? Explain its properties.

1046

What do you mean by an execution plan? Why is it used? How would you view it?

884

Explain differentiate between a having clause and a where clause?

858

Do you know what is normalization of database? What are its benefits?

1042

What are commonly used odbc functions in php?

981