Difference between a query and strored procedure?
- 4 Answers
- 8753 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / tathagoto
query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
When is the explicit cursor used ?
How much does sqlite cost?
What are different types of functions in sql?
How do I run a sql query in pgadmin 4?
Explain the difference between 'between' & 'and' operators in sql
How to use boolean type in select statement?
What is a table?
Enlist the advantages of sql.
what is sub-query? : Transact sql
Is sqlexception checked or unchecked?
How to create an array in pl/sql?
Does inner join remove duplicates?
What is %s in sql?
What are the different dml commands in sql?
What are the popular database management systems in the it industry?
