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
10520 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 a unique index be created on a column, which contains null?

877

What is microsoft sql server?

911

What is the difference between a view and a stored procedure?

967

How much does sql server 2016 cost?

985

What is a view in sql?

921

How do you size a resultset?

873

What is the purpose of self join?

910

Can we call stored procedure in trigger?

904

How to use union to merge outputs from two queries together in ms sql server?

1001

What are the parts of a function?

864

What is the difference between Clustered and Non-Clustered Index?

1008

Tell me the use of keyword with encryption. Create a store procedure with encryption?

958

How to perform key word search in tables?

906

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

How to rebuild master databse?

1026