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

How to use order by with union operators in ms sql server?

1060

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1110

Do you know the different ddl commands in sql?

1096

Is candidate a key?

1000

What is importing utility?

1034

Do you know what are the differences between lost updates and uncommitted dependencies?

1132

When should you use an instead of trigger?

1017

Explain the working of sql privileges?

1141

How to create a testing table with test data in ms sql server?

1135

Can we create clustered index on composite key?

1159

What are xml indexes?

998

How to turn on the mssql api module in php?

1118

What is resultset concur_updatable?

1051

What is Extended user-defined?

1023

Define magic tables in sql server?

1112