Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76836 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / robinson
The execution plan will be created when compiling the stored
procedure and permanently stored in the database and so it
is much efficient, But in the case of query the execution
plan will be created at runtime.
| Is This Answer Correct ? | 30 Yes | 9 No |
Post New Answer View All Answers
Explain Normalization and DE normalization
What is the difference between stored procedure and functions?
How do clustered indexes store data?
What are out-of-range errors with date and time literals?
What does COMMIT command do?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
How do you test your database? : sql server database administration
What are partitioned views?
What is a join in sql?
What is the sql server 2000 version number?
Define cross join in sql server joins?
How many levels of sp nesting is possible?
How to insert data with null values?
How to loop through result set objects using odbc_fetch_row()?
