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

Explain what role entity and relationship play in an ER diagram.

1016

What are indexes in ms sql server?

996

Can you explain full-text query in sql server?

969

Why does sql studio use a single registered database repository? : sql server management studio

951

Explain syntax for dropping triggers?

884

explain declarative management framework (dmf) in sql server 2008?

949

How to create function without parameter in sql server?

990

Explain about local stored procedure?

901

Do you know exporting and importing utility?

972

What is wrong with sql server client libarary dll, ntwdblib.dll?

993

How you provide security to cube? : sql server analysis services, ssas

921

How to how to convert numeric expression data types using the convert() function??

989

What are the rules to use the rowguidcol property to define a globally unique identifier column?

964

What is query optimization process?

939

How to convert a unicode strings to non-unicode strings?

1028