I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6443 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Is stored procedure faster than query?
Is vs as in pl sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is the maximum number of rows in sql table?
What is the difference between in and between in sql?
How can I speed up sql query?
Can a table contain multiple primary key’s?
Explain character-manipulation functions?
What is the use of index in hive?
What is the use of <> sql?
What is pl sql and why it is used for?
What is the difference between a procedure and a function?
What is sql engine in oracle?
What is difference between mysql and postgresql?
how to include character strings in sql statements? : Sql dba
