yep problem is with the compiler.. I had to think of another way to solve

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 / lee

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

Answer Posted / lee

yep problem is with the compiler.. I had to think of
another way to solve the problem, eg, I created the #temp
without the IF statement and then used an IF ELSE statement
to modify or update #temp, make sense?

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain user defined functions?

950

What do you understand by physical_only option in dbcc checkdb?

944

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

909

What is the boxing and unboxing concept in .net?

876

Is truncate autocommit?

902

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2891

What are the filtered indexes?

983

What are the types of database recovery models?

1062

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2187

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1911

How to insert data with null values?

977

How to add the custom code in Report?

120

What do you understand by triggers?

871

How do clustered indexes store data?

1060

How to create a view using data from another view?

911