Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76227 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
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is a collation?
What are the transaction properties?
What are Row versions of DataRow?
What is TDS(Tabular Data Stream) Gateway?
How to drop an existing user defined function in ms sql server?
How do you set a trace flag in sql server?
What is view in sql?
What is cursors? And what are the different types of cursor?
Can we call stored procedure in view in sql server?
Why variables called the most powerful component of ssis?
What is sparse columns of sql server 2008?
How to create prepared statements using odbc_prepare()?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How we create SQL Server 2005 Reporting Services ? Give me Sample
