Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71849 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
How to convert character strings into numeric values?
How to concatenate two strings in SQL Server.
tell me the disaster recovery plan
Where to find ntwdblib.dll version 2000.80.194.0?
What is the difference between Clustered and Non-Clustered Index?
What are the advantages of user-defined functions over stored procedures in sql server?
What are sparse columns?
Where do we use trace frag?
Explain tables in SQL Azure?
What is transact-sql ddl trigger?
How can you set the threshold at which sql server will generate keysets asynchronously?
What are sql server procedures?
What is the process of indexing?
Explain about Normalization?
What is the cartesian product of table?
