Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77463 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
How much is a sql server license?
What do I need to start working with sql studio? : sql server management studio
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What functions can a view be used to performed?
How do I view a procedure in sql server?
explain different types of constraints? : Sql server database administration
Can we do dml on views?
Why do we need different type of parameter?
What are “phantom rows”?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How you can minimize the deadlock situation?
How to get the definition of a stored procedure back?
What are the new features of sql server 2012 reporting service?
Can sql servers link to other servers like oracle?
