Answer / sudipta santra

A simple query because through query we can throw the result
of the data based on conditions but in stored procedure we
can not , as the procedure is used for the specific time
based for the specific value return through out/IN out .

A simple query is best. But it is wrong that we can not do
through a proc, we can do but the effort will take more.

Answer / john

simple query s best as we can issue query by giving various
condition and it will not get stored in database where as a
procedure will get stored in database and gotta occupy
memory.so its waste of memory and time to create a
procedure rather than issuing a si9ngle query

What is sqlexception in java?

0 Answers  

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

What is left join in postgresql?

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---

Does group by remove duplicates?

0 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

Is ms sql is free?

0 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What do you understand by case manipulation functions?

0 Answers  

---