What is a virtual table in sql?

0 Answers  

---

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   IBM,

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

what is an sql server?

1 Answers  

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

Explain the difference between function and stored procedure?

0 Answers  

---

How do you set a trace flag in sql server?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

What is the use of @@spid?

0 Answers  

---

What are dml triggers and types of dml triggers?

0 Answers  

---

What is the system function to get the current user's user id?

2 Answers   HCL,

---