Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71777 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / prakash
1. SP is easy to allocate GRANT AND REVOKE (Privileges)
Rights for user
2. SP is execute more faster than query statement
3. SP, is already compiled Object
4. Query is Sql Statement where as SP batch of Sql Statement
5. In a query memory management is more high than the SP
| Is This Answer Correct ? | 27 Yes | 8 No |
Post New Answer View All Answers
How to delete existing triggers using "drop trigger"?
How do I perform an unattended install of sql server 2000?
How you can change a cross join into an inner join?
How to generate create procedure script on an existing stored procedure?
What is the osql utility?
write an SQL query to list the employees who joined in the month of January?
Mention what are the core components of ssrs?
Where the sql logs gets stored?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Explain primary key, foreign key and unique key?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How to name query output columns in ms sql server?
What is field with example?
What does the on update no action do?
What is the current pricing model of SQL Azure?
