What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

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,

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

How do you size a resultset?

0 Answers  

---

---

Can we use where clause in union?

0 Answers  

---

What is tempdb in sql server?

0 Answers  

---

How will you decide the active and passive nodes?

0 Answers  

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---