What is the purpose of a table?

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,

---

How many cores do I need for sql server 2016?

0 Answers  

---

What is tablesample?

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

---

How do you debug a procedure in sql server?

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

What are the four main query statements?

7 Answers   Wipro,

---