What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What are “lock” hints?

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

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,

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

How to rename an existing column with sql server management studio?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What are constraints?

0 Answers  

---

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

---

What is the benefit of normalization?

0 Answers  

---