Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71667 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / raghuraja, sivaganga, india
Advantage in Programming - If you are using Query in your
program exe, want to change Query, you have to change query
and compile it again. But if used Stored procedure, no need
to recompile just modify the sp. Query is slow and SP is
fast.
| Is This Answer Correct ? | 30 Yes | 10 No |
Post New Answer View All Answers
Describe the left outer join & right outer join. : sql server database administration
How to verify a login name with sqlcmd tool?
Can two different columns be merged into single column? Show practically?
Where are sql server usernames and passwords stored in the sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is the difference between index seek vs. Index scan?
What do you mean by sql server 2005 express management tools?
Explain microsoft sql server functions?
Where are SQL server users names and passwords are stored in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
How to convert character strings into numeric values?
what is blocking? : Sql server database administration
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is a constant or literal in ms sql server?
Do you know what is blocking?
