Because temp is being used by database internally so that it is same as a

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

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

Answer Posted / gaurav

Because temp is being used by database internally so that it
is same as a system table so this table can't create by user...

Is This Answer Correct ?

1 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you insert values in multiple rows using one Insert statement?

1098

What does set rowcount do?

909

What is normalization and denormalization in sql server?

1016

What is the default schema of your login session in ms sql server?

1049

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

What are the ways available in sql server to execute sql statements?

1135

What is difference between inner join and join?

1044

What methods do you follow to protect from sql injection attack?

1029

Why we need sql server?

965

How optimize sql query with multiple joins in sql server?

901

What do you understand by hotfixes and patches in sql server?

991

How can I create a new template for import ? : sql server management studio

1071

What is GUID in sql server?

1165

Are connections to sql server encrypted?

1003

What is the difference between composite index and covering index?

953