I need to write a simple query,which one is better select
statement or stored procedure?and why?
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
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Why is theta join required?
Why partition by is used in sql?
What is use of trigger?
What is a sql statement?
What are commit, rollback, and savepoint?
What is offset in sql query?
How to return multiple rows from the stored procedure?
Can you load data into multiple tables at once? : aql loader
How to disable a trigger name update_salary?
What is pl sql and why it is used for?
How do I save a stored procedure?
what is commit? : Sql dba
What is denormalization in a database?
What are analytical functions in sql?