Difference between writing SQL query and stored procedure ?
Answer Posted / vial
stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses
Is This Answer Correct ? | 77 Yes | 21 No |
Post New Answer View All Answers
What are the main sources of data?
How do I view a trc file?
What are the types of sql server?
Does partitioning help performance?
What is a covering index?
Write an sql query to find first weekday of the month?
Explain different forms of normalization?
Why we use trigger in sql server with example?
What is normalization process?
What is the difference between a "where" clause and a "having" clause?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How to list all columns in a table using odbc_columns()?
How to handle error or exception in sql?
Can you type more than one query in the query editor screen at the same time?
Do you know what is a linked server in sql server?