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

Does an index slow down updates on indexed columns?

1031

How to create view in stored procedure sql server?

1049

What is the difference between truncate and delete commands?

1105

What command must you use to include the not null constraint after a table has already been created?

1227

How do I start and stop sql server?

1057

How can I check if a view exists in a sql server database?

1072

Can binary strings be converted into numeric or float data types?

1089

What is buffer cash in sql server?

1199

Why we need sql server?

1006

Explain steps of normalization?

1059

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1016

Delete duplicate rows without using rowid.

1582

How to execute a stored procedure in ms sql server?

1245

what is sql server? : Sql server database administration

1036

Mention the 3 ways to get a count of the number of records in a table.

1025