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
- 6997 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
What is the usage of when clause in trigger?
Can we have two clustered index on a table?
What is a sql instance vs database?
Explain what is dbms?
How do I view a sql trace file?
what are the drivers in mysql? : Sql dba
What is rank function in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
Does asenumerable execute the query?
What is materialized view in sql?
How do you create an update query?
explain commit and rollback in mysql : sql dba
What is a data definition language?
How to connect a sql*plus session to an oracle server?
Define concurrency control. : Transact sql
