Difference between writing SQL query and stored procedure ?
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 to retrieve error messages using odbc_errormsg()?
What is indexing a document?
What are types of subqueries?
What is Federation and Federation Member?
Tell me what is sql profiler?
Explain why variables called the most powerful component of ssis?
How many types of database relationship in sql server?
Can we join two tables without primary key?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Can you index views?
When would you use sql joins?
What is the purpose of sql profiler in sql server?
Explain the difference between control flow and data flow?
Name some of the open source software that you can use in alternative to SSR?
What is the difference between a function and a stored procedure?