Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76806 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
Explain what are the database objects? : SQL Server Architecture
What is xdr?
Why use “in” clause in sql server?
Is a primary key unique?
Why use sub query in sql server and list out types of sub queries?
What are truncate options available in sql server? : sql server database administration
How to access the deleted record of an event?
What does executeupdate return?
Can sql servers linked to other servers?
Where can you find the error log information? : sql server database administration
What are clustered and non-clustered index?
Where the sql logs gets stored? : sql server database administration
How will you go about resolving deadlocks?
What is master database? : SQL Server Architecture
How to change the system date and time from SQL Plus Terminal ?
