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

What is log shipping?

962

Explain transaction server isolation?

1045

How to download and install microsoft .net framework version 2.0?

1139

How to use subqueries with the exists operators in ms sql server?

1119

How to create an index on an existing table in ms sql server?

981

Will the writetext statement activate a trigger?

1095

Tell me can we use custom code in ssrs?

1003

What is TDS(Tabular Data Stream) Gateway?

121

Explain about Joins?

993

What is a field name?

968

Define union, union all, minus, intersect?

980

List the different index configurations possible for a table?

934

How do you drop an index?

925

What is the Control Flow in SSIS

1094

What is attribute hierarchy? : sql server analysis services, ssas

1021