Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76205 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
What is a field in a table?
Does server sql treat char as a variable-length or fixed-length column?
What are the disadvantages of using querystrings to send data from one page to another?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Write a sql query to get zero records from a table having n number of records?
How to replace null values in expressions using isnull()?
How to change the ownership of a schema in ms sql server?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Explain the properties of subqueries in sql server?
What is coalesce and check constraint in sql server?
What is repeatable read?
How do you create type- insensitive operator?
explain databases and sql server databases architecture? : Sql server database administration
How to update a field in SQL after ALTERING a row?
What are the tools available in market as an alternative to sql server reporting services?
