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
- 7113 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
what is the different between now() and current_date()? : Sql dba
What does sql stand for?
What is data type in database?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the difference between inner join and natural join?
What is primary key and foreign key?
What is the use of prepared statement?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Which function is used to return remainder in a division operator in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why primary key is required?
List the ways to get the count of records in a table?
Can we create index on primary key?
Does sql full backup truncate logs?
what is a record in a database ? : Sql dba
