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
- 7028 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to run pl sql program in mysql?
who introduced sql?
give the syntax of grant and revoke commands? : Sql dba
What is dense_rank in sql?
What are the benefits of pl/sql packages?
Write a sql select query that only returns each name only once from a table?
Explain lock escalation? : Transact sql
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Explain the working of foreign key?
How to return multiple rows from the stored procedure?
Is left join same as inner join?
what is a relationship and what are they? : Sql dba
How do I partition in sql?
What is difference between stored procedures and application procedures?
What is string join?
