Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76791 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 change data capture (cdc) feature?
Characterize join and name diverse sorts of joins?
What is the use of group by clause?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is a View ? Can we insert, Update and delete a view?
Write down the syntax and an example for create, rename and delete index?
What are the different subsets of sql?
what types of replication are supported in sql server? : Sql server database administration
Define views.
What are the different types of replication you can set up in sql server?
How to execute stored procedure and set temp table in sql server?
What is amo? : sql server analysis services, ssas
Do I need a report server to run reports in my application?
is there a column to which a default can't be bound? : Sql server database administration
What are the rules to use the rowguidcol property to define a globally unique identifier column?
