Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76933 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
wat wil hapn if we give the both read and deny read permission to user?
What are 3 ways to get a count of the number of records in a table?
What are alternate keys?
What is the maximum length of an alert name?
How to delete an existing database user?
What are different types of database indexes?
What are the different types of sub-queries?
What are the character string functions supported by sql server 2005?
Explain Geometry datatype in sql server 2008 with example
What is a select query statement in ms sql server?
Explain about analysis services?
how to trace the traffic hitting a sql server? : Sql server database administration
Explain about SQLOS?
What are xml indexes?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
