Interested to Buy Any Domain ? << Click Here >> for more details...
I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 7110 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 truncate ddl or dml?
how to install mysql? : Sql dba
What is mutating table error?
Why coalesce is used in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Why are sql stored procedures used?
What is a heap in sql?
Mention what does the hierarchical profiler does?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is 'mysqlimport'? : Sql dba
How to return an array from java to pl/sql?
Why do we use joins in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the example of procedure?
What are aggregate and scalar functions?
