Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71676 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
Should you normalize audio?
Explain the difference between function and stored procedure?
What is shared lock?
What is indexing explain it with an example?
Explain about protocol layer present in SQL server?
What is dirty page?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Can a trigger be created on a view?
Equi join and non equi join is possible with sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
How do I change my passwords (database, LDAP, and so on) without causing an outage?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How to provide column names in insert statements in ms sql server?
What are the tool windows in sql server management studio? : sql server management studio
Can select statements be used on views in ms sql server?
