I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6012 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 trigger in sql and its types?
Is sql the best database?
What is sql comments?
What are the possible values that can be stored in a boolean data field?
What is normalization? How many normalization forms are there?
How do I start pl sql?
What are the different dml commands in sql?
How do I save a sql query?
How to select 10 records from a table?
What's the procedure?
how to create a new view in mysql? : Sql dba
how to convert character strings to numeric values? : Sql dba
How to execute a stored procedure?
what is text? : Sql dba
What is the difference between microsoft access and sql?
