Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76956 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
Which are new data types introduced in sql server 2008?
What is the difference between deallocate cursor and close cursor?
Explain system views?
What triggers long term care?
Explain the functionalities that views support?
What is sql server profiler trace data file?
Can you insert NULL in unique column?
What kind of problems occurs if we do not implement proper locking strategy?
Tell me the phases a transaction has to undergo?
How do I create a stored procedure in sql server?
What is logshipping and its purpose?
What is SQL Azure Federations?
What are the advantages of mirroring?
How can i Relate Tables in SSIS
What does sql server mean?
