Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76224 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / anbu arunmozhi
Query execute every time when ever u call that statement
but stored procedure execute only one time v can used every time it should be very efficient compare query
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I view a stored procedure in sql server?
What is master database? : SQL Server Architecture
Explain the disadvantages of cursors?
What is the partitioning method?
What is "scheduled jobs" or "scheduled tasks"?
Difference between 2NF &3NF ?
What is table level trigger?
Can we perform backup restore operation on tempdb? : sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Is truncate a dml command?
what is difference between view and Dip.
What is the importance of three tier architecture?
What is the difference between count () and rowcount ()?
What is the default order of an order by clause?
How can sql server instances be hidden? : sql server security
