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

Can we write trigger for view?

1010

Explain the usage of floor function in sql server.

964

Why should you use or avoid select * statements?

1030

What are cascading parameters in ssrs reports?

230

How to define the name and server for a new dsn?

1119

What are scalar functions?

1000

Can we create clustered index on composite key?

1084

How do you create a data source?

911

What is transactional replication?

967

How to find the version of sql server? : sql server database administration

1111

Define primary key?

1138

How to start sql server browser service?

1135

What is a trigger and types of a trigger?

983

What is equi join with example?

1130

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1138