Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76856 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 much is a sql server license?
Difference between report and query parameter. Why do we need different type of parameter?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is primary key and example?
What is user-defined function?
Can we linked SharePoint to a SQL database?
How to generate create function script on an existing function?
What it means to be triggered?
What is service broker? : sql server database administration
What happens if null values are involved in arithmetic operations?
what is the main function of a query parameter?
Do you know the different ddl commands in sql?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
Explain throw statement in sql server 2008?
