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
- 9595 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
Hiiii
in Stored Procedures we cannot create same temp table twice if it is in IF else conditions also
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain what are commit and rollback in sql?
Explain what is sql server english query?
What is a subquery in a select query statement in ms sql server?
What is the definition for sql server 2000?
Explain difference between control flow and data flow?
Explain in details security in SQL azure?
How many types of keys are there?
What is the difference between osql and query analyzer?
How to create dbo table in sql server?
What are audit control procedures?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is database black box testing?
What is function of master database?
What are the advantages of policy management?
