Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76207 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / kshitij s. nirmaley
query and stored procedure do the same thing but the
difference is that a query should be compiled every time the
query is executed, while the stored procedure is in compiled
form when executed first time .If we use stored procedure
we can avoid recompilation of the query.
| Is This Answer Correct ? | 23 Yes | 5 No |
Post New Answer View All Answers
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain comment on transactions?
Explain different types of lock modes in sql server 2000?
Explain contrast amongst grouped and non-bunched records?
How to bind a view to the schema of the underlying tables?
How would we use distinct statement? What is its use?
Tell me what is difference between clustered and non clustered index?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Why do you want to join software field as you have done your BE in Electronics?
Explain how to send email from sql database?
Can you explain full-text query in sql server?
What are four major operators that can be used to combine conditions on a where clause?
What is a field in a table?
Can we use pragma autonomous_transaction in trigger?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
