Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76925 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 do you create type- insensitive operator?
How to loop through result set objects using mssql_fetch_array()?
How to select all columns of all rows from a table with a select statement in ms sql server?
what is a sub-report?
What are distinctive joins find as a part of sql?
What is cte (common table expression)?
What is the difference between mysql and mysqli?
What is difference between getdate and sysdatetime in sql server 2008?
Mention the command used to rename the database.
What stored by the msdb?
How will you know when statistics on a table are obsolete?
What is model database in sql server?
Describe in brief sql server monitoring ways.
what is package and it uses and how can u call a package
What are the key configuration files for sql server reporting services ?
