Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 10537 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / murthy
The #Temp table created in this stores procedure exists in
memory as long as the Particular session is closed. Hence
drop the table at the end of the procedure.
Note: In case if you exec the SP using Management studio,
close the connection and re-open it, it will work without
modifying anything.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is difference between clustered index and non clustered index?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain the use of containers in ssis and also their types?
What is the difference between createstatement and preparedstatement?
What is a join in sql? What are the types of joins?
What are the differences between local and global temporary tables?
What is the difference between varchar and varchar(max) datatypes?
What stored procedure would you use to view lock information?
Explain an incremental backup?
Is mysql the same as sql server?
What method is used by the Command classes to execute SQL statements that return single values?
What are scheduled tasks in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How to create function with parameter in sql server?
