I need to write a simple query,which one is better select statement or stored

I need to write a simple query,which one is better select
statement or stored procedure?and why?

Question Posted / sujeethkumar

2 Answers
6020 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I need to write a simple query,which one is better select statement or stored procedure?and why?..

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.

Is This Answer Correct ?

5 Yes

1 No

I need to write a simple query,which one is better select statement or stored procedure?and why?..

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

Is This Answer Correct ?

4 Yes

0 No

Post New Answer