What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

does physical index sort data

1 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

Are resultset updatable?

0 Answers  

---

---

How to copy the tables, schema and views from one sql server to another?

0 Answers  

---

What's the maximum size of a row?

4 Answers   IBM,

---

State the difference between union and union all?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

Explain difference between cross join and full outer join?

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---