Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77018 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 execute a sql statement using mssql_query()?
How to change parameter value inside the report?
What is difference between drop truncate and delete?
How do you trace the traffic hitting a sql server?
What is the purpose of object explorer and its features? : sql server management studio
What is the purpose of the master database?
How can you find out which stored procedures are recompiling?
Define master database?
Why use “pivot” in sql server?
How to use wildcard characters in like operations in ms sql server?
What is open database communication (odbc)?
How to create a trigger for insert only?
How can we get count of the number of records in a table?
Can you explain different types of joins?
Is null in sql server?
