Because, Stored procedure is pre-compiled language.

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 / utpal chakraboarty

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

Answer Posted / utpal chakraboarty

Because, Stored procedure is pre-compiled language.

Is This Answer Correct ?

4 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql view?

1005

Difference between Inner vs outer joins?

938

What are the types of containers in ssis?

1158

What is a performance monitor?

963

How to backup encryption key ?

182

How to Sync Two SQL Azure Databases?

119

What is apply operator in sql?

1002

What is enhanced database mirroring in sql server 2008?

959

How to declare and use cursor variables?

1153

How to create a store procedure with encryption?

992

Where are stored procedures in sql server?

1057

when you create a database how is it stored? : Sql server database administration

1006

What is the difference between stored procedure and functions?

1115

can you implement data mining in SSRS?

146

What are the advantages of passing name-value pairs as parameters?

1159