What are the advantages of stored procedure in sql server?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

How to create a local temporary stored procedure?

0 Answers  

---

---

What happens when converting big values to integers?

0 Answers  

---

What is ms sql server index?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

Explain the different index configurations a table can have?

0 Answers  

---

What is isnull() operator?

0 Answers  

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

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,

---