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
10805 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 the distinction amongst delete and truncate?

1056

Differentiate between mongodb vs. Sql server?

1081

How do you size a resultset?

908

When to use Inner join & when to use subquery?

1150

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

1008

Explain the etl (extraction, transformation, and loading)?

988

what are the new features introduced in sql server 2000? : Sql server database administration

905

Why de-normalization required?

995

Explain the concepts and capabilities of sql server?

965

What command is used to delete a table from the database in the sql server and how?

1103

What is fill factor and pad index?

1005

What are policy management terms?

981

Can sub report data source be different from that of the parent report?

142

in the physical file layout, where should the transaction log be stored in relation to the data file?

986

What is Transparent Data Encryption?

994